Calculating before and after

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Drisconsult - 15 May 2006 16:15 GMT

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?

Signature

Drisconsult

Reply to this Message

Andy - 15 May 2006 16:28 GMT

Hi

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

Andy.

> Hello All
>
[quoted text clipped - 5 lines]
> driven go over the 500 Klms limit, and then each klm drops to 25 Kenya
> Shillings. Can this be done in one calculation?

Reply to this Message

Peo Sjoblom - 15 May 2006 16:33 GMT

Try

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

Regards,

Peo Sjoblom

> Hello All
>
[quoted text clipped - 5 lines]
> driven go over the 500 Klms limit, and then each klm drops to 25 Kenya
> Shillings. Can this be done in one calculation?

Reply to this Message

Drisconsult - 15 May 2006 17:32 GMT

Hello Peo

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

Regards
Terence
London

Signature

Drisconsult

Reply to this Message