mercredi 25 juillet 2018

Excel Multiple If Statements showing False

I have this IF statement:

=IF(AG3<=7,"1",IF(15<=AG3<=21,"2",IF(22<=AG3<=28,"3",IF(29<=AG3<=35,"4",IF(36<=AG3<=42,"5",IF(43<=AG3<=49,"6",IF(50<=AG3<=56,"7")))))))

but either it gives me a 1 or "FALSE"

All the values are within the ranges and should be showing various numbers

Aucun commentaire:

Enregistrer un commentaire