Multiple IF statements
Hi, I'm attemping to assign PRICE to items based on CONDITION and CATEGORY but my limited skills with formulas are keeping me from my desired results. I'm hoping some one can help me out.
In my PRICE column if have the following formula. It works for the "Chair" category but nothing else. Any guidance is appreciated.
=IF(AND(Condition@row = "Fair"), IF(Category@row = "chair", "$5.00"), IF(AND(Condition@row = "good"), IF(Category@row = "chair", "$10.00"), IF(AND(Condition@row = "excellent"), IF(Category@row = "chair", "$15.00"), IF(AND(Condition@row = "Fair"), IF(Category@row = "storage", "$10.00"), IF(AND(Condition@row = "good"), IF(Category@row = "storage", "$20.00"), IF(AND(Condition@row = "excellent"), IF(Category@row = "storage", "$30.00"), IF(AND(Condition@row = "Fair"), IF(Category@row = "Large Furniture", "$25.00"), IF(AND(Condition@row = "good"), IF(Category@row = "large furniture", "$50.00"), IF(AND(Condition@row = "excellent"), IF(Category@row = "large furniture", "$75.00"), IF(AND(Condition@row = "Fair"), IF(Category@row = "small furniture", "$5.00"), IF(AND(Condition@row = "good"), IF(Category@row = "small furniture", "$10.00"), IF(AND(Condition@row = "excellent"), IF(Category@row = "small furniture", "$15.00")))))))))))))
Thank you!
Ken
Best Answer

Try this:
=IF(AND(Condition@row = "fair", Category@row = "chair"), 5, IF(AND(Condition@row = "good", Category@row = "chair"), 10, IF(AND(Condition@row = "excellent", Category@row = "chair"), 15, IF(AND(Condition@row = "fair", Category@row = "storage"), 10, IF(AND(Condition@row = "good", Category@row = "storage"), 20, IF(AND(Condition@row = "excellent", Category@row = "storage"), 30, IF(AND(Condition@row = "fair", Category@row = "large Furniture"), 25, IF(AND(Condition@row = "good", Category@row = "large furniture"), 50, IF(AND(Condition@row = "excellent", Category@row = "large furniture"), 75, IF(AND(Condition@row = "fair", Category@row = "small furniture"), 5, IF(AND(Condition@row = "good", Category@row = "small furniture"), 10, IF(AND(Condition@row = "excellent", Category@row = "small furniture"), 15, "not found"))))))))))))
Format your Price column for $.
Answers

Try this:
=IF(AND(Condition@row = "fair", Category@row = "chair"), 5, IF(AND(Condition@row = "good", Category@row = "chair"), 10, IF(AND(Condition@row = "excellent", Category@row = "chair"), 15, IF(AND(Condition@row = "fair", Category@row = "storage"), 10, IF(AND(Condition@row = "good", Category@row = "storage"), 20, IF(AND(Condition@row = "excellent", Category@row = "storage"), 30, IF(AND(Condition@row = "fair", Category@row = "large Furniture"), 25, IF(AND(Condition@row = "good", Category@row = "large furniture"), 50, IF(AND(Condition@row = "excellent", Category@row = "large furniture"), 75, IF(AND(Condition@row = "fair", Category@row = "small furniture"), 5, IF(AND(Condition@row = "good", Category@row = "small furniture"), 10, IF(AND(Condition@row = "excellent", Category@row = "small furniture"), 15, "not found"))))))))))))
Format your Price column for $.

That did it. You rock! Thank you very much!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 142 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!