Nested IF and

nkosikhona.msani89271 · 05/20/19

I trying to use to create a sheet that I will use to determine the status by comparing 2 status and then give an answer the e.g. If the status1 is low and status 2 is low the actual status should be low, I used the following IF/AND Statement and it worked fine:

=IF(AND([Status1]3 = "Low"; [Status2]3 = "Low"); "Low"; " ")

But now if I try to nest another I/AND statement like below, I get

=IF(AND([Status1]1 = "Low"; [Status2]1 = "Low"); "Low"; " "; IF(AND([Status1]1 = "High"; [Status2]1 = "High"); "High"; " "))

I Get #INCORRECT ARGUMENT SET.

Please assist what wrong with my formula.

Nic Larsen · 05/20/19

Try this:

=IF(AND([Status1]@row = "Low"; [Status2]@row = "Low"); "Low"; IF(AND([Status1]@row = "High"; [Status2]@row = "High"); "High"))

sean59916 · 05/20/19

Hi,

I came up with 2 solutions to this question - using IF/AND and another using concatenation -

=IF(AND([Status1]8 = "Low", [Status2]8 = "Low"), "Low", IF(AND([Status1]8 = "High", [Status2]8 = "High"), "High", ""))

=IF([Status1]1 + [Status2]1 = "LowLow", "Low", IF([Status1]1 + [Status2]1 = "HighHigh", "High", ""))

See images - I hope this helps.

Sean

nkosikhona.msani89271 · 05/21/19

Hi, Thank you for your assistance both solutions worked and I can see where I making a mistake.

Nested IF and

Comments

Help Article Resources

Categories