Nested If Statement - help needed

Jed Rusyniak

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. 

Andrée Starå

Hi Jed,

Try something like this.

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

The same version but with the below changes for your and others convenience.

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

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Missed an operator in the second IF...

 

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

Andrée Starå

Nice catch!

Thanks!

Paul Newcome

No worries. 

Jed Rusyniak

Thanks for the help guys.  It is working, but not exactly how I need it to.  I need the cell to return the value "Yusen Needs PRO#s" if the difference in the count from ([PRO Number]9 - [Trailer#]9) is equal to or less than 10.

Jed Rusyniak

For example in the screen shot above the value of 11-3 = 8 and should be returning the value of Yusen Needs PRO#s but it isn't doing that. 

Andrée Starå

Happy to help!

If I understand you correctly you'd probably only have to change places between the text.

OK and Need. 

Ok?

Best,

Andrée

 

Jed Rusyniak

thanks...now I am in business. 

Andrée Starå

Excellent!

I'm always happy to help!

Best,

Andrée