Nesting multiple IF statements inside OR statement

Jezza

Andrée Starå

Hi @Jezza

I hope you're well and safe!

Try something like this. (update columns names to yours)

=IF(CheckA@row = 1, 10, IF(CheckB@row = 1, 20, IF(CheckC@row = 1, 30)))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

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!

Jezza

Hi,

I'm trying to do something that seems very basic and yet SS keeps providing #parseable errors. I have 3 check box columns and want to return a result based on WHICH box is checked. I.E. if column 1 is checked = 10, if column 2 checked = 20, if column 3 checked = 30, etc etc.

Only one column would ever be checked. Individually the formulas work (checking IF a box is checked) but combining them gives me an error every time.

Can you not create nested formulas in SS such as: =OR( IF statement1, IF statement 2, ETC)

This is the formula I am using that gives me the error:

=OR((IF(A@row = 1, "20", "")),(IF(B@row=1,"35","")),(IF(C@row=1,"12,"")))

Andrée Starå

Hi @Jezza

I hope you're well and safe!

Try something like this. (update columns names to yours)

=IF(CheckA@row = 1, 10, IF(CheckB@row = 1, 20, IF(CheckC@row = 1, 30)))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

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!

Jezza

Andrée,

Thank you! This worked perfectly. I had assumed it would require an OR statement with multiple IFs but I guess not.

Cheers!

Andrée Starå

@Jezza

Excellent!

Happy to help!

✅Remember! 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!