Hi All,

I need a formula for the following see attached Sheet.

Brief

Starting at 50klm distance the base rate is $1.50

Every 50klm more I want the rate to increase $0.25

I have it set up so when you enter the Distance (KLM) (sourced via Google Search) 

The Quantity needs to rounds up to the next whole number according to Distance(KLM) entered

The rate increase needs to corresponds with Quantity total.

Any help would be appreciated. Thank you

​  Hi All, I need a formula for the following see attached Sheet. BriefStarting at 50klm distance the base rate is $1.50Every 50klm more I want the rate to increase $0.25 I have it set up so when you enter the Distance (KLM) (sourced via Google Search) The Quantity needs to rounds up to the next whole number according to Distance(KLM) enteredThe rate increase needs to corresponds with Quantity total. Any help would be appreciated. Thank you    Read More

​