mercredi 6 juillet 2016

Excel IF function greater than x but less than y

I'm trying to arrange a column so that I can essentially "score" results.. I am looking for a formula that will go "If greater than 100000 but less than 110000 = 10, if greater than 90000 but less than 999999 = 9, etc etc.. can someone help?

Aucun commentaire:

Enregistrer un commentaire