Tiered Prcing Formula - Calc Pricing

Copper Contributor

Looking for a formula to calc the below.

 

 

0-50  Flat Fee of $5.00
51-70 @ .009 ea
71-90 @ .007 ea

51 would = 5.009

7 Replies

HI @DWiser 

 

Please try below formula:

 

=IF(D4<51,5,IF(D4<71,5+(D4-50)*0.009,5+(D4-50)*0.007))

 

A sample file is also attached for your reference please let me know if it works as desired.

Thanks

Tauqeer

@tauqeeracma 

 

Thanks - but I forgot a couple of tiers...

 

0-50  Flat Fee of $5.00
51-70 @ .009 ea
71-90 @ .007 ea
91-150 @ .005 ea
151-200 @ .0040 ea
210+ @ .0035 ea

 

 

 

 

@tauqeeracma 

Thanks - but I forgot a couple of tiers...

 

0-50  Flat Fee of $5.00
51-70 @ .009 ea
71-90 @ .007 ea
91-150 @ .005 ea
151-200 @ .0040 ea
210+ @ .0035 ea

 

@tauqeeracma 

 

Thanks - but I forgot a couple of tiers...

 

0-50  Flat Fee of $5.00
51-70 @ .009 ea
71-90 @ .007 ea
91-150 @ .005 ea
151-200 @ .0040 ea
210+ @ .0035 ea

 

THANKS in advance.

@DWiser 

 

Following up on @tauqeeracma 's response:

=IF(D4<51,5,IF(D4<71,5+(D4-50)*0.009,IF(D4<91,5+(D4-50)*0.007,IF(D4<151,5+(D4-50)*0.005,IF(D4<210,5+(D4-50)*0.004,5+(D4-50)*0.003)))))

@PReagan 

 

Thank you!

 

dw

@DWiser 

 

You're welcome!