IF function to return result based on drop downs not working
I have a column with 6 different drop down values ("cover class") and want to multiply the "acres" column by a different value depending on what was selected in "cover class."
This formula only works if the first value ("1: 0-5%") is selected, otherwise it returns "#invalid operation."
I know this is clunky. Any help is appreciated.
=IF([cover class]@row = "1: 0-5%", acres@row * 0.025, =IF([cover class]@row = "2: 6-25%", acres@row * 0.155, =IF([cover class]@row = "3: 26-50%", acres@row * 0.38, =IF([cover class]@row = "4: 51-75%", acres@row * 0.63, =IF([cover class]@row = "5: 76-95%", acres@row * 0.88, =IF([cover class]@row = "6: 96-100%", acres@row * 0.98, 0 = IF([cover class]@row = "", "", 0)))))))
Best Answer
-
Delete all equals in front of "IF" except the first equal.
=IF([cover class]@row = "1: 0-5%", acres@row * 0.025, IF([cover class]@row = "2: 6-25%", acres@row * 0.155,
Answers
-
Delete all equals in front of "IF" except the first equal.
=IF([cover class]@row = "1: 0-5%", acres@row * 0.025, IF([cover class]@row = "2: 6-25%", acres@row * 0.155,
-
Worked like a charm, many thanks! I guess I shouldn't be ashamed of a rookie mistake, since I'm a rookie. :)
-
Happy to help.😁
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!