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
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