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
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!