Calculating before and after

[Drisconsult]

Hello All

I have a calcualtion that adds up all klms driven up to 500 klms, then
multiplies this number by 35 Kenya Shillngs to give the total amount
that can be claimed. Absolute beginners stuff.

However I am having problems with the calculation if the total klms
driven go over the 500 Klms limit, and then each klm drops to 25 Kenya
Shillings. Can this be done in one calculation?

 

[Guest]

Hi

Try something like this:
=(A2*35)+IF(A2>500,(A2-500)*0.25,0)

Andy.

"Drisconsult" <[email protected]>
wrote in message
news[email protected]...

 

[Peo Sjoblom]

Try

=MIN(500,A1)*35+MAX(0,A1-500)*25


Regards,

Peo Sjoblom

 

[Drisconsult]

Hello Peo

You are a gentleman sir. It worked like a dream. Many thanks for
getting my brain into gear.

Regards
Terence
London