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

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

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

"Mahendra" wrote:

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

Try this.
=IF(AND(H6=B6,I6=C6),"Bal",IF(AND(H6B6,I6C6),1))

"Mahendra" wrote:

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