software

I would like to analys following:

we store certain numbers of paletts in warehouse every month. W/H rent
is calculated on gliding price terms:
if the value is
Palett numerslt;730 = 0€
From 731- 800 paletts = 12,25 € per palett
from 801-850 paletts = 11,50 € per palett
from 851-900 palett = 11,00 € per palett

How will I analys in Excel , how much rent I have to pay for additional
paletts. Here please see the attached table.

Kind regards
ukapadia--
ukapadia
------------------------------------------------------------------------
ukapadia's Profile: www.excelforum.com/member.php...oamp;userid=30789
View this thread: www.excelforum.com/showthread...hreadid=504462
ukapadia Wrote:
gt; I would like to analys following:
gt;
gt; we store certain numbers of paletts in warehouse every month. W/H rent
gt; is calculated on gliding price terms:
gt; if the value is
gt; Palett numerslt;730 = 0€
gt; From 731- 800 paletts = 12,25 € per palett
gt; from 801-850 paletts = 11,50 € per palett
gt; from 851-900 palett = 11,00 € per palett
gt;
gt; How will I analys in Excel , how much rent I have to pay for additional
gt; paletts. Here please see the attached table.
gt;
gt; Kind regards
gt; ukapadia

See if this works for you ...

=IF(A1lt;731,0,IF(A1lt;801,12.25*A1,IF(A1lt;851,11.5*A1, 11*A1)))

Regards.--
BenjieLop------------------------------------------------------------------------
BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=504462
thanks!!!!!--
ukapadia
------------------------------------------------------------------------
ukapadia's Profile: www.excelforum.com/member.php...oamp;userid=30789
View this thread: www.excelforum.com/showthread...hreadid=504462
thanks!!!!!--
ukapadia
------------------------------------------------------------------------
ukapadia's Profile: www.excelforum.com/member.php...oamp;userid=30789
View this thread: www.excelforum.com/showthread...hreadid=504462