dimanche 28 octobre 2018

IF, AND, OR function with multi conditions in Excel

how to combine these 3 formula in one ?

=IF(F39<=20000;(F39)*0.1)

=IF(AND(20000<F39;F39<=50000);(F39)*0.15)

=IF(F39>50000;(F39)*0.2)

Aucun commentaire:

Enregistrer un commentaire