Forum Discussion

DWiser's avatar
DWiser
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
excel
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Sep 30, 2019

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

DWiser's avatar
DWiser
Copper Contributor
Sep 30, 2019

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

 

 

 

 

  • DWiser's avatar
    DWiser
    Copper Contributor
    Oct 01, 2019

    @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

     

Resources