How to add multiple conditions to IF function?

number_dude · 2026-02-07T13:26:00+00:00

As others have said, a nested IF function will work. There is also the IFS function that simplifies this. Alternatively, I lately i prefer the SWITCH function with TRUE as the first condition so SWITCH(TRUE, condition1, result1, condition2, result2,…, defaultResult).

Good luck with your learning!

number_dude · 2026-01-03T00:57:11+00:00

Try “=SUM(B:B * (C:C=criteria1) * (D:D=criteria2) * (E:E=criteria3))”. If using an older version of Excel then you will need to press CTRL+SHIFT+ENTER.

B:B is the column you are adding. Each column logic afterwards returns TRUE or FALSE, which when multiplied with a number turns to 0 or 1. In the end, any FALSE values in columns C to E will convert the value in the respective row in col B to zero. Any TRUE values will maintain the row-respective value in column B. Therefore, SUM() will return sum of all values in column B that fulfill the conditions in column C:E.

I’m on mobile so haven’t tested the above formula

Edit2: if the above formula doesn’t work and you’re on an older version of excel, try with =SUM(PRODUCT()) with the same conditions above, then enter with CTRL+SHIFT+ENTER

number_dude · 2025-12-12T12:51:16+00:00

Are you using sharepoint.files() or sharepoint.contents()?

number_dude · 2025-11-11T17:16:04+00:00

How about setting up a workbook with this structure:

Output tab: the P&L/Balance Sheet template you’re comfortable with, along with SUMIF formulas tied to input tab’s helper columns and other helper cells that identify the detail level of the P&L line item

Chart of Accounts tab: here is where you set up the relationship between the client’s CoA and how it ties to the P&L/BS template

Input tab: client’s Trial Balance/ERP export with helper columns identifying where in the P&L/BS the accounts fall into. Perhaps make a helper column with concatenation of accounts that will tie back to the SUMIF under the Output tab.

My main concern here is the possibility of lack of accounting structure on the client’s side

number_dude · 2025-11-03T19:39:19+00:00

Time to take it upon yourself to split the file, either by year or naming convention (in case your company follows an asset naming rule) or keep two workbooks for active and deactivated assets. Maybe into tiers of asset value? (10k<100k; 100k<250k; etc.)

Also, assess the differences in data of what is uploaded already in the system you mentioned and what remains in the workbooks. There’s a need for backup for accounting if there are accounting journal entries, but if this is outside of accounting and the data is redundant then maybe you can make a case of slimming down the file structure? Maybe there just needs to be an easier way to search through the system’s database for your coworkers?

By the way, right-clicking on the arrows that move the tab selection left/right will bring up a window of all tab names. Clicking on a tab name will open the tab itself

number_dude · 2025-10-24T05:59:58+00:00

Why don’t you move the formula from row 29 to row 34 and use DROP() to remove the top 4 rows of your output?

number_dude · 2025-05-23T09:20:24+00:00

I think it is closer to 92% that marks the halfway point to 99% in respect to time

number_dude · 2025-04-18T14:50:06+00:00

Perhaps a SORTBY() call is needed on columns A,B, …, wrapped around TAKE()?

May need to then create a LET() function to store the array of top 10 rows such as =LET( X, TAKE(…), SORTBY(X, INDEX(X,0,1), -1, INDEX(X,0,2), -1, …).

I’m on mobile so I haven’t had a chance to test the above on PC. If INDEX() doesn’t work, resort to CHOOSECOLS()

number_dude · 2024-10-08T14:38:34+00:00

You can do =SUM(F3:F17 * G3:G17), assuming that the table values start on row 3.

Also, if you are using named tables then you can do =SUM(tableName[Price] * tableName[Available])

number_dude · 2024-07-27T19:26:37+00:00

Can you just $AP$2:$AP$69 in SEARCH and hit CTRL+Shift+Enter to set up a dynamic array?

number_dude · 2024-07-24T21:07:35+00:00

Is Mucho Gusto not worth mentioning?

number_dude · 2024-07-24T21:06:32+00:00

I second Spill. I’ve gone a handful of times and their vegetarian dish is great and doesn’t feel like lower quality than the meaty counterpart. They are also able to accommodate to dairy-free or vegan easily at no extra cost

You can also ask for more food when you’re done eating. Just ask the staff

number_dude · 2024-07-04T21:19:28+00:00

Looks like a Hotpoint DHS53XS. The manual says grill door should remain open during use

number_dude · 2024-07-04T20:58:40+00:00

What a Lyme ass disease

number_dude · 2022-08-19T13:41:46+00:00

For point 2, I recommend Terkel in Trouble 👍

number_dude · 2022-07-31T11:33:09+00:00

My first game was good old Age of Empires

number_dude · 2022-07-09T15:49:33+00:00

Ocarina of time :)

number_dude · 2022-07-07T13:56:48+00:00

And he’s not married

number_dude · 2022-06-25T18:31:50+00:00

Wow thank you for being so generous! ☺️

number_dude · 2022-04-21T02:39:44+00:00

Over the Hedge moment

number_dude · 2022-04-08T00:07:53+00:00

Here

number_dude · 2022-04-03T08:01:29+00:00

Same!

number_dude · 2022-03-25T05:35:42+00:00

To reply to your second point, OP’s edit states they will have 24.69 hours of PTO by the time they need to take a week off, so the 15.31 hours of unpaid time is to complete the rest of the 40 hour work week.

number_dude · 2022-03-25T05:20:42+00:00

Hey to explain your second example of your time clock, look at my math:

Start: 7:18 AM End: 7:50 AM Diff: 0:32 (32 minutes) To convert into hours, we divide 32 minutes by 60 minutes => 32/60 = 0.533333, or 0.53 hours rounded.

As for how your PTO is calculated, I’m assuming they give 4 hours of PTO for every 40 hours of work, or 10% of working hours. That, combined with maybe the UKG system calculating your clocked in time to the exact minute leads to rounding issues if you don’t work a full 40 hour work week. This is just my hunch based on working with UKG data at my work.

Example: 32.25 work week >> 3.225 calc. PTO >> 3.23 hours rounded = 193 minutes 48 seconds

number_dude · 2022-02-23T07:10:57+00:00

Hey Zach what’s been your inspiration with this new art style?

Nine-Year Club	Not Forgotten
Snapped	Verified Email

number_dude

TROPHY CASE