Sep 30 2019 10:16 AM - edited Sep 30 2019 10:40 AM
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
Sep 30 2019 11:35 AM
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
Sep 30 2019 11:59 AM
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
Oct 01 2019 06:45 AM
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
Oct 01 2019 07:08 AM
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.
Oct 01 2019 07:39 AM
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)))))