Formula not working
I have the follow formula. (See Below)
=IF($Status4 = "Close", [ME BUD]4 * $[ME BUD]$2),IF($Status4<>"Close","Open"
If $Status4 = "Close" the formula returns a value. However, if $Status4 is not equal to "Close" I want the formula to return "Open". I get the following response #UNPARAEABLE The formula does work if I only use the following: =IF($Status4 = "Close", [ME BUD]4 * $[ME BUD]$2) I either get a value or the cell is blank
Any suggestions?
Best Regards,
ds
Best Answer
-
=IF($Status4 = "Close", [ME BUD]4 * $[ME BUD]$2, "Open")
Don't forget that if statements return if true AND if false, not a true and next.
Answers
-
=IF($Status4 = "Close", [ME BUD]4 * $[ME BUD]$2, "Open")
Don't forget that if statements return if true AND if false, not a true and next.
-
Thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 405 Global Discussions
- 216 Industry Talk
- 456 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!