Tiered Prcing Formula - Calc Pricing

Question

Looking for a formula to calc the below.&nbsp;&nbsp;0-50&nbsp; Flat Fee of $5.0051-70&nbsp;@ .009 ea71-90&nbsp;@ .007 ea51 would = 5.009

tauqeeracma · Answer

HI&nbsp;DWiser&nbsp;&nbsp;Please try below formula:&nbsp;=IF(D4&lt;51,5,IF(D4&lt;71,5+(D4-50)*0.009,5+(D4-50)*0.007))&nbsp;A sample file is also attached for your reference please let me know if it works as desired.ThanksTauqeer

dwiser · Answer

tauqeeracma&nbsp;&nbsp;Thanks - but I forgot a couple of tiers...&nbsp;0-50&nbsp; Flat Fee of $5.0051-70&nbsp;@ .009 ea71-90&nbsp;@ .007 ea91-150&nbsp;@ .005 ea151-200&nbsp;@ .0040 ea210+&nbsp;@ .0035 ea&nbsp;&nbsp;&nbsp;&nbsp;

dwiser · Answer

@tauqeeracma&nbsp;Thanks - but I forgot a couple of tiers...&nbsp;0-50&nbsp; Flat Fee of $5.0051-70&nbsp;@ .009 ea71-90&nbsp;@ .007 ea91-150&nbsp;@ .005 ea151-200&nbsp;@ .0040 ea210+&nbsp;@ .0035 ea&nbsp;

dwiser · Answer

tauqeeracma&nbsp;&nbsp;Thanks - but I forgot a couple of tiers...&nbsp;0-50&nbsp; Flat Fee of $5.0051-70&nbsp;@ .009 ea71-90&nbsp;@ .007 ea91-150&nbsp;@ .005 ea151-200&nbsp;@ .0040 ea210+&nbsp;@ .0035 ea&nbsp;THANKS in advance.

preagan · Answer

DWiser&nbsp;&nbsp;Following up on&nbsp;@tauqeeracma&nbsp;'s response:=IF(D4&lt;51,5,IF(D4&lt;71,5+(D4-50)*0.009,IF(D4&lt;91,5+(D4-50)*0.007,IF(D4&lt;151,5+(D4-50)*0.005,IF(D4&lt;210,5+(D4-50)*0.004,5+(D4-50)*0.003)))))

Forum Discussion

Tiered Prcing Formula - Calc Pricing

7 Replies

Resources