# Tiered Prcing Formula - Calc Pricing

Highlighted
Occasional Contributor

# Tiered Prcing Formula - Calc Pricing

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
Highlighted

# Re: Tiered Prcing Formula - Calc Pricing

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

Highlighted

# Re: Tiered Prcing Formula - Calc Pricing

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

Highlighted

# Re: Tiered Prcing Formula - Calc Pricing

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

Highlighted

# Re: Tiered Prcing Formula - Calc Pricing

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

Highlighted

# Re: Tiered Prcing Formula - Calc Pricing

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)))))

Highlighted

Thank you!

dw

Highlighted

You're welcome!