Multiple conditions formula to generate cost field

Question

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 this case or what Function I need to use.

quickbasecoachd · Answer

If ([Miles]&gt;&nbsp; &nbsp; 0 and [Miles&nbsp; &lt;= 150, "$450,[Miles]&gt;150 and [Miles] &lt;= 200, "$600",.. then a value for when Miles is &gt; 200)

mikeklausing · Answer

Perfect, that works great.&nbsp;Thanks for the quick reply as always Mark.

mikeklausing · Answer

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?

deldridgdeldrid · Answer

This can be done in a Case statement.&nbsp; The formula stops when the first match is found.&nbsp; Try something like this:Case(True,&nbsp; [Miles]&lt;=0, 0,&nbsp; [Miles]&lt;=150, 450,&nbsp; [Miles]&lt;=200, 600,&nbsp; 0)The last zero is what's returned if nothing else matches.&nbsp; (You didn't specify what should happen if miles &gt; 200.) &nbsp;

quickbasecoachd · Answer

please post a new question and if you are referencing another post, provide a link to that post.

Forum Discussion

Multiple conditions formula to generate cost field

Related Content

Check one field for multiple conditions

PDF Document Generator, automatically attached to a record

Using Grid Edit to Edit Multiple Records at Once

Conditional formula url

If statement with multiple conditions