Nested If Statement - help needed

Jed Rusyniak
Jed Rusyniak ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I'm trying to get this formula to work. 

 

=IF([PRO Number]9 - [Trailer #]9 > 10), " PRO Levels: OK", IF([PRO Number]9 = [Trailer #]9, "Yusen Needs PRO#s")))

 

I want to trigger the IF/Then statement if the value of ([PRO Number]9 - [Trailer#]9) is equal to or less than 10.  See screen shot below. 

Screen Shot 2019-05-02 at 10.42.05 AM.png

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!