lundi 21 novembre 2016

4 nested IF conditions in Excel not accepted "you've entered too many arguments for this function"

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