Forum Discussion

Copper Contributor

Sep 30, 2019

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

Copper Contributor

Oct 01, 2019

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.

Bronze Contributor

Oct 01, 2019

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