jeudi 26 juillet 2018

Excel If/And Statement, Multiple

I need a formula that will display "10" in a cell if another cell is between 10.00-12.49. If it is between 12.50-19.99, I need it to display 12.50. Finally, if it is over 20.00, I need it to display 20.00.

Aucun commentaire:

Enregistrer un commentaire