gliding price
 

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

gliding price
 

ukapadia Wrote:
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

See if this works for you ...

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

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=504462

gliding price
 

thanks!!!!!


--
ukapadia
------------------------------------------------------------------------
ukapadia's Profile: http://www.excelforum.com/member.php...o&userid=30789
View this thread: http://www.excelforum.com/showthread...hreadid=504462

gliding price
 

thanks!!!!!


--
ukapadia
------------------------------------------------------------------------
ukapadia's Profile: http://www.excelforum.com/member.php...o&userid=30789
View this thread: http://www.excelforum.com/showthread...hreadid=504462