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)

MikeKlausing's avatar
MikeKlausing
Qrew Assistant Captain
6 years ago
Mark- I followed a previous post of yours on how to use a URL formula to pull up google maps and generate a distance between two points. I have made it that far and google maps will say its 500 miles total. Is there a way to get the "500" miles back over to a field in my quickbase form without manually typing it in?