Hey everyone,
I’m running into a bit of a wall with some logical functions (the whole IF, AND, OR thing) in Microsoft Excel. I've got this specific scenario where I need two different sets of conditions to trigger a result. Basically, I want the cell to say YES if either Column A >= 10 and Column B >= 2, OR if Column A >= 15 and Column B >= 3. If neither of those situations is met, it should just say NO.
So, I tried putting together this formula: =IF(AND(A3>=10;B3>=2;"DA");OR(IF(AND(A3>=15;B3>=3);"DA";"NE")))
But, for some reason, it keeps spitting back an error—specifically, I'm getting that annoying #VALUE! message.
Any chance someone could help me figure out what I'm doing wrong?
Best,
S.
I’m running into a bit of a wall with some logical functions (the whole IF, AND, OR thing) in Microsoft Excel. I've got this specific scenario where I need two different sets of conditions to trigger a result. Basically, I want the cell to say YES if either Column A >= 10 and Column B >= 2, OR if Column A >= 15 and Column B >= 3. If neither of those situations is met, it should just say NO.
So, I tried putting together this formula: =IF(AND(A3>=10;B3>=2;"DA");OR(IF(AND(A3>=15;B3>=3);"DA";"NE")))
But, for some reason, it keeps spitting back an error—specifically, I'm getting that annoying #VALUE! message.
Any chance someone could help me figure out what I'm doing wrong?
Best,
S.