Forum Discussion

MikeKlausing's avatar
MikeKlausing
Qrew Assistant Captain
6 years ago

Multiple conditions formula to generate cost field

I am looking to generate a cost field for "freight" where its based on miles away.  If (([Miles]>0 but <=150), "$450. ([Miles]>150 but <=200), "$600") I am unsure if an "IF" formula works in thi...
Formulas and functions
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
If (
[Miles]>    0 and [Miles  <= 150, "$450,
[Miles]>150 and [Miles] <= 200, "$600",

.. then a value for when Miles is > 200)