Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|