Need help with an IF statement / Add 50% to formula result

Options

Hello,

I've wrecked my brain trying to figure out the formula just to add 50% to the returned value. I got close but it seems to be off by a few dollars. I also will need to use this in an IF formula.

If Express Check = N then =SUM[Column2]@row - 5000) * 0.64 + 11002.5 total is 11017.86

• My formula =SUM([Column2]@row - 5000) * [Column2]3 + [Column2]4

If Express Check = Y then 50% needs to be added to 11017.86

I was first trying to figure out how to add the 50% to returned value and this is as far as I got:

• My formula =SUM(SUM([Column2]@row - 5000) * [Column2]3 + [Column2]4) + ([Column2]@row - 5000) * [Column2]3 + [Column2]4 * 0.5

I hope this makes sense.

• ✭✭✭✭✭✭
Options

Try something like this...

=(SUM([Column2]@row - 5000) * [Column2]3 + [Column2]4) * IF([Column Name]1 = "Y", 1.5)

Basically what this does is initially runs your base calculation. Then if the cell = "Y" it will multiply it by 1.5 (which adds 50%). If the cell does not equal "Y", then it just leaves the base calculation.

• Options

Thanks, Paul! The formula added 50% if checked yes, but when I change the Express Check = N, it zeros out the results opposed to doing the basic calculation.

• ✭✭✭✭✭✭
Options

That sort of makes sense. Let's try this... If it is "Y" then multiply by 1.5, otherwise multiply by 1.

=(SUM([Column2]@row - 5000) * [Column2]3 + [Column2]4) * IF([Column Name]1 = "Y", 1.5, 1)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!