Multiple IF AND Nesting Formulas


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!