Is there any formula to calculate a fixed increase with a fixed price?

**ec4excel** · 08-09-2012, 11:32 AM

Dear All,

I need help to create a formular to calculate the following condition:

Minimum cost is $300 for 800kg, and every increase of 300kg will be an additional cost of $50

How to write a formula if I have 3050kg, how much will it cost?

I can only write the first if statement, which is if(3050<=800,300,?????)

Please help

**jeffreybrown** · 08-09-2012, 11:39 AM

Hello & Welcome to the Forum,

Does this help?

Please Login or Register  to view this content.

**Ace_XL** · 08-09-2012, 11:44 AM

Maybe..

=IF(A1<=800,300,300+((A1-800)/300)*50)

**ec4excel** · 08-09-2012, 11:57 AM

Dear Jeffrey,

Thank you very much, your formula works!!

But don't know why I cannot reply to your post.

**K m** · 08-09-2012, 12:15 PM

I think this is what you want.
The formulas above do not account for the in between numbers For Example: 1,235

=if(a1<=800,300,roundup((a1-800)/300,0)*50+300)