vendredi 6 février 2015

Excel IF statement less than , between and greater than

I'm trying to write a query that returns a specific value based on an IF.


I've tried using the below to help me but just get errors


Stack OverFlow 15753961


Basically what I'm trying to do is



=IF(F6 < 10000 THEN "SmallTrack" WHEN BETWEEN 10000 AND 25000 THEN "FastTrack" ELSE "MultiTrack")


But obviously in excel language. Cells would contain numbers from 1 to 50000.


Aucun commentaire:

Enregistrer un commentaire