Forum Discussion
Solved
Formula Required
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...
pjukes Yes! That one works. But, oh my, how colorful and an almost abusive use of conditional formatting. You really want all of that?
Anyhow, enter the formula below in E2 and I believe it does what you ask for.
=1.5+(INT([@[DISTANCE (KLM)]]/50)-1)*0.25
Try this one.
pjukes Yes! That one works. But, oh my, how colorful and an almost abusive use of conditional formatting. You really want all of that?
Anyhow, enter the formula below in E2 and I believe it does what you ask for.
=1.5+(INT([@[DISTANCE (KLM)]]/50)-1)*0.25