My IF nesting formula is not working
My formula: =IF(AND(Status@row = "Completed", [Remaining Amount]@row = "0"), OR([Payment Status]@row = "Payment", [Payment Status]@row = "Undefined"), "Paid") is not working. I want to show "Paid" if status is completed AND remaining amount is zero but payment status must be either Payment OR Undefined. Formula works but is not considering Remaining amounts= 0. It's displaying Paid when remaining amount has a value Help!!
Best Answer
-
No problem. Glad it works for you! It looks like you were just needing to nest the OR function within your AND function.
Answers
-
It looks like you put your closed parentheses on the AND statement too early. Try this:
=IF(AND(Status@row = "Completed", [Remaining Amount]@row = "0", OR([Payment Status]@row = "Payment", [Payment Status]@row = "Undefined")), "Paid")
Hope this helps!:)
-
OMG, thanks @brianschmidt . I spent hours moving this whole formula around... LOL
-
No problem. Glad it works for you! It looks like you were just needing to nest the OR function within your AND function.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!