Nested If Statement - help needed
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.
0
Comments
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
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
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"))
thinkspi.com
Nice catch!
Thanks!
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
No worries.
thinkspi.com
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.
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.
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
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
thanks...now I am in business.
Excellent!
I'm always happy to help!
Best,
Andrée
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.