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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!