# #unparsable error when using =IF(AND

Hello.

New here! :)

I have an =IF formula that works fine with one set of information, e.g. =IF(AND(Calculation14 > 0, Calculation14 < 3), "Continue as planned")

But I want to add other options, such as: =IF(AND(Calculation14 > 0, Calculation14 < 3), "Continue as planned"), =IF(AND(Calculation14 > 3, Calculation14 < 9), "Seek advice"))

As soon as I add the second IF, it becomes unparsable.

Where am I going wrong?

Thanks

Katie

• If I am understanding correctly what you are looking for the below formula should work.

=IF(AND(Calculation14 > 0, Calculation14 < 3), "Continue as planned", IF(AND(Calculation14 > 3, Calculation14 < 9), "Seek advice"))

• Hi @KatieDi

I hope you're well and safe!

If possible, I'd recommend using the @row feature instead of the row number.

=IF(AND(Calculation@row > 0, Calculation@row < 3), "Continue as planned", IF(AND(Calculation@row > 3, Calculation@row < 9), "Seek advice"))

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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 for help with Smartsheet, integrations, general workflow advice, or anything else.

• Hi KatieDi

I hope you are doing well,

Use this formula

=IF(AND([Calculation14]@row > 0, [Calculation14]@row < 3), "Continue as planned", IF(AND([Calculation14]@row > 3, [Calculation14]@row < 9), "Seek advice", ""))

In the formula, when calculation14 column has value 3 and 9 then output will show blank.

Use this calculation if your situation is like Calculation14 column less than and equal to 3, which means "Continue as planned," and Calculation14 column less than and equal to 9, which means "Seek advice"

=IF(AND([Calculation14]@row > 0, [Calculation14]@row <= 3), "Continue as planned", IF(AND([Calculation14]@row > 3, [Calculation14]@row <= 9), "Seek advice", ""))

I hope this is useful to you, Have a Good Day.

Thanks

Shubham Umale, Smartsheet Engineer, Ignatiuz Software

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!