Multiple If Statements


Nested formulas and I are not friends.

This works without putting more than one statement in here, what am I doing wrong and with multiple statements?

=IF(OR([How many xyz]@row = "0-3 xyz", "$50-100K")), IF(OR([xyz?]@row = "4-10 xyz", "100-300K")))

Best Answer


  • vjschmid

    Thank you! Worked like a charm!!! And thanks for the great explanation.

  • Randy Van Winkle

    If an "IF" value is referencing a range of values in the formula, what is the syntax? i.e. If between 1-100, then X, If 100-200 then Y

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!