Multiple IF AND Nesting Formulas

Options

Trying to return a number based on the GVWR column, we have multiple GVWR's and want to return differnt numbers in the TARE column. I keep getting a syntax error and can't figure out why. Ultimately there will be 5 options, showing two below. It works with one IF formula.

=IF(GVWR@row = 9500, 5840), IF(AND(GVWR@row = 9950, 6740))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!