Need help with an IF statement / Add 50% to formula result
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.
Answers

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.

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.

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
Categories
Check out the Formula Handbook template!