Forum Discussion
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...
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.
Thanks. That worked. Question, what are the "" for at the end of the equation?
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.
- Thanks so much.
