IF statement with text as logical condition

[mysticloud]

Hi,

I'm trying to create a formula which will give a positive, negative, and indeterminate interpretation based on the values entered on separate cell. But I can't seem to get the logical condition that uses text to work. The formula I'm using is: =IF(OR(AND(A8>=2,A5>=4),AND(A8<2,A5>=6)),"POSITIVE.",IF(AND(A8<2,A5>=4,A5<6),"NEGATIVE (see comment***).",IF(AND(A8>=2,A5<4),"NEGATIVE (see comment*).",IF(AND(A8<2,A5<4),"NEGATIVE.",IF(AND(A8="N/A",A5="N/A"),"INDETERMINATE', ""ERROR")))))

I can't seem to get the last IF statement to work.

Can someone help me? Thank you.

[arthurbr]

Duplicate
https://www.excelforum.com/excel-for...ml#post5088146

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. I am, therefore, closing this thread, but you may continue here in the original thread:https://www.excelforum.com/excel-for...ml#post5088146