lundi 19 novembre 2018

Having trouble in nested IFs in excel with true or false values in each IF statement

=IF(AND(A2<=20151231),(B2=0) 0, 15, IF(AND(A2>=20190101,B2>=2),15, 7.5))

This is what I entered in the function.

if A2 is less than 20151231 and B2 is equal to 0 the value will be 0. if A2 is greater than 20190101 and B2 is equal to or greater than 2 the value will be 15.

the problem is that excel says that I entered too many arguments and when I try to derive it it says that there is something wrong with the function I entered.

Aucun commentaire:

Enregistrer un commentaire