Excel: I have 3 if conditions that I want to apply in order (if else if else if)
=IF(AND(VALUE(RIGHT(TEXT(INT(A9);"0");1))<4;A9>30);INT(A9)-RIGHT(TEXT(INT(A9);"0");1)+4;"NOT_TRUE";)
=IF(AND(VALUE(RIGHT(TEXT(INT(A9);"0");1))<7;A9>30);INT(A9)-RIGHT(TEXT(INT(A9);"0");1)+7;"NOT_TRUE";)
=IF(AND(VALUE(RIGHT(TEXT(INT(A9);"0");1))<9;A9>30);INT(A9)-RIGHT(TEXT(INT(A9);"0");1)+9;"NOT_TRUE";)
I put them together (nested) (Inside each other) Like this
=IF(AND(VALUE(RIGHT(TEXT(INT(A9);"0");1))<4;A9>30);INT(A9)-RIGHT(TEXT(INT(A9);"0");1)+4;"NOT_TRUE";IF(AND(VALUE(RIGHT(TEXT(INT(A9);"0");1))<7;A9>30);INT(A9)-RIGHT(TEXT(INT(A9);"0");1)+7;"NOT_TRUE";IF(AND(VALUE(RIGHT(TEXT(INT(A9);"0");1))<9;A9>30);INT(A9)-RIGHT(TEXT(INT(A9);"0");1)+9;"NOT_TRUE";)))
Now Excel gives me an error message saying "you've entered too many arguments for this function"
What can I do ?
Aucun commentaire:
Enregistrer un commentaire