gliding price

  • Thread starter Thread starter ukapadia
  • Start date Start date
U

ukapadia

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 said:
I would like to analys following:

we store certain numbers of paletts in warehouse every month. W/H ren
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 additiona
paletts. Here please see the attached table.

Kind regards
ukapadia
Click to expand...

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
 
Back
Top