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 numers<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: http://www.excelforum.com/member.php...o&userid=30789
View this thread: http://www.excelforum.com/showthread...hreadid=504462