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?


--
Drisconsult
------------------------------------------------------------------------
Drisconsult's Profile: http://www.excelforum.com/member.php...o&userid=34459
View this thread: http://www.excelforum.com/showthread...hreadid=542142

Hi

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

Andy.

"Drisconsult" <(E-Mail Removed)>
wrote in message
news(E-Mail Removed)...
>
> 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?
>
>
> --
> Drisconsult
> ------------------------------------------------------------------------
> Drisconsult's Profile:
> http://www.excelforum.com/member.php...o&userid=34459
> View this thread: http://www.excelforum.com/showthread...hreadid=542142
>

Try

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


Regards,

Peo Sjoblom


"Drisconsult" wrote:

>
> 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?
>
>
> --
> Drisconsult
> ------------------------------------------------------------------------
> Drisconsult's Profile: http://www.excelforum.com/member.php...o&userid=34459
> View this thread: http://www.excelforum.com/showthread...hreadid=542142
>
>

Hello Peo

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

Regards
Terence
London


--
Drisconsult
------------------------------------------------------------------------
Drisconsult's Profile: http://www.excelforum.com/member.php...o&userid=34459
View this thread: http://www.excelforum.com/showthread...hreadid=542142