IF function to return result based on drop downs not working

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!