Forum Discussion

Copper Contributor

Jan 02, 2018

Solved

Sumif formula need help

I use an excel spreadsheet to enter payroll data for our company. I have one cell that calculates our 401K match (which we pay 100% up to 3% and 50% from 3% to 5%). I would like to have this cell o...

Formulas & Functions

Need Help

IngeborgHawighorst
Jan 02, 2018
Hello,

change the formula in cell D20. I'm not quite clear what that formula is, but it seems to be something like

=(B14*0.03)+(((B14*0.05)-(B14*0.03))*0.5)

If you want this formula to calculate only when B14 is greater than 0, then wrap that formula into an IF() function, not a SumIF. IF() has the syntax IF(condition, do when true, do when false)

=if(B14>0,(B14*0.03)+(((B14*0.05)-(B14*0.03))*0.5),"")

In words: if B14 is greater than 0 then do the calculation, else return a blank.

Let me know if that helps.

IngeborgHawighorst

MVP

Jan 02, 2018

Hello,

change the formula in cell D20. I'm not quite clear what that formula is, but it seems to be something like

=(B14*0.03)+(((B14*0.05)-(B14*0.03))*0.5)

If you want this formula to calculate only when B14 is greater than 0, then wrap that formula into an IF() function, not a SumIF. IF() has the syntax IF(condition, do when true, do when false)

=if(B14>0,(B14*0.03)+(((B14*0.05)-(B14*0.03))*0.5),"")

In words: if B14 is greater than 0 then do the calculation, else return a blank.

Let me know if that helps.

Carol Van Valkenburg

Copper Contributor

Jan 02, 2018

Thanks. That worked. Question, what are the "" for at the end of the equation?

IngeborgHawighorst
MVP
Jan 02, 2018
The two double quotes are an empty text. They sit in the part for "do when false". So, if the condition is not met, a blank is returned.
- Carol Van Valkenburg
  Copper Contributor
  Jan 02, 2018
  Thanks so much.