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.