#unparsable error when using =IF(AND

KatieDi

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

Hollie Green

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"))

Andrée Starå

Hi @KatieDi

I hope you're well and safe!

To add to Hollie's excellent advice/answer.

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!

Shubham

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