# 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)))))))

• ✭✭✭✭✭✭
Options

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,

• ✭✭✭✭✭✭
Options

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,

• ✭✭
Options

Worked like a charm, many thanks! I guess I shouldn't be ashamed of a rookie mistake, since I'm a rookie. :)

• ✭✭✭✭✭✭
Options

Happy to help.😁

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!