What's wrong=IF(AND(H6>B6, I6>C6),1, IF(AND(H6=B6, I6=C6),"EQUAL",

M

Mahendra

I am on a scale of 1-10, 4 in excel, I am trying to try nested if's, and I
get every value to the last value of else which is "-1". I am missing
something, could you tell me please? Thanks in advance
 
M

Mahendra

I already got this answer, it was just a mis-match in the comparisons, hence
defaulting to "-1". Please do not respond.
 
Top