jeudi 2 novembre 2017

Excel IF AND Statement

I have the IF AND Statement below and value in Cell A1 is 10 but the statement is returning blank.

=IF(AND(A1>1, A1<20,((A1/10)*5)), "")

Aucun commentaire:

Enregistrer un commentaire