Home

Tiered Prcing Formula - Calc Pricing

%3CLINGO-SUB%20id%3D%22lingo-sub-883032%22%20slang%3D%22en-US%22%3ETiered%20Prcing%20Formula%20-%20Calc%20Pricing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-883032%22%20slang%3D%22en-US%22%3E%3CP%3ELooking%20for%20a%20formula%20to%20calc%20the%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E0-50%26nbsp%3B%20Flat%20Fee%20of%20%245.00%3CBR%20%2F%3E51-70%26nbsp%3B%40%20.009%20ea%3CBR%20%2F%3E71-90%26nbsp%3B%40%20.007%20ea%3CBR%20%2F%3E%3CBR%20%2F%3E51%20would%20%3D%205.009%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-883032%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-883224%22%20slang%3D%22en-US%22%3ERe%3A%20Tiered%20Prcing%20Formula%20-%20Calc%20Pricing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-883224%22%20slang%3D%22en-US%22%3E%3CP%3EHI%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F417539%22%20target%3D%22_blank%22%3E%40DWiser%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20try%20below%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIF(D4%26lt%3B51%2C5%2CIF(D4%26lt%3B71%2C5%2B(D4-50)*0.009%2C5%2B(D4-50)*0.007))%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20sample%20file%20is%20also%20attached%20for%20your%20reference%20please%20let%20me%20know%20if%20it%20works%20as%20desired.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-883264%22%20slang%3D%22en-US%22%3ERe%3A%20Tiered%20Prcing%20Formula%20-%20Calc%20Pricing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-883264%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20-%20but%20I%20forgot%20a%20couple%20of%20tiers...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E0-50%26nbsp%3B%20Flat%20Fee%20of%20%245.00%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E51-70%26nbsp%3B%40%20.009%20ea%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E71-90%26nbsp%3B%40%20.007%20ea%3C%2FSPAN%3E%3CBR%20%2F%3E91-150%26nbsp%3B%40%20.005%20ea%3CBR%20%2F%3E151-200%26nbsp%3B%40%20.0040%20ea%3CBR%20%2F%3E210%2B%26nbsp%3B%40%20.0035%20ea%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-885924%22%20slang%3D%22en-US%22%3ERe%3A%20Tiered%20Prcing%20Formula%20-%20Calc%20Pricing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-885924%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThanks%20-%20but%20I%20forgot%20a%20couple%20of%20tiers...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E0-50%26nbsp%3B%20Flat%20Fee%20of%20%245.00%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E51-70%26nbsp%3B%40%20.009%20ea%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E71-90%26nbsp%3B%40%20.007%20ea%3C%2FSPAN%3E%3CBR%20%2F%3E91-150%26nbsp%3B%40%20.005%20ea%3CBR%20%2F%3E151-200%26nbsp%3B%40%20.0040%20ea%3CBR%20%2F%3E210%2B%26nbsp%3B%40%20.0035%20ea%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-885973%22%20slang%3D%22en-US%22%3ERe%3A%20Tiered%20Prcing%20Formula%20-%20Calc%20Pricing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-885973%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20-%20but%20I%20forgot%20a%20couple%20of%20tiers...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E0-50%26nbsp%3B%20Flat%20Fee%20of%20%245.00%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E51-70%26nbsp%3B%40%20.009%20ea%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E71-90%26nbsp%3B%40%20.007%20ea%3C%2FSPAN%3E%3CBR%20%2F%3E91-150%26nbsp%3B%40%20.005%20ea%3CBR%20%2F%3E151-200%26nbsp%3B%40%20.0040%20ea%3CBR%20%2F%3E210%2B%26nbsp%3B%40%20.0035%20ea%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHANKS%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886067%22%20slang%3D%22en-US%22%3ERe%3A%20Tiered%20Prcing%20Formula%20-%20Calc%20Pricing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886067%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F417539%22%20target%3D%22_blank%22%3E%40DWiser%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFollowing%20up%20on%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%3CSPAN%3E%26nbsp%3B's%20response%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3DIF(D4%26lt%3B51%2C5%2CIF(D4%26lt%3B71%2C5%2B(D4-50)*0.009%2CIF(D4%26lt%3B91%2C5%2B(D4-50)*0.007%2CIF(D4%26lt%3B151%2C5%2B(D4-50)*0.005%2CIF(D4%26lt%3B210%2C5%2B(D4-50)*0.004%2C5%2B(D4-50)*0.003)))))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886101%22%20slang%3D%22en-US%22%3ERe%3A%20Tiered%20Prcing%20Formula%20-%20Calc%20Pricing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886101%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edw%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886447%22%20slang%3D%22en-US%22%3ERe%3A%20Tiered%20Prcing%20Formula%20-%20Calc%20Pricing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886447%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F417539%22%20target%3D%22_blank%22%3E%40DWiser%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20welcome!%3C%2FP%3E%3C%2FLINGO-BODY%3E
DWiser
Occasional Contributor

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

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

@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

 

 

 

 

@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

 

@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

 

THANKS in advance.

@DWiser 

 

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

@PReagan 

 

Thank you!

 

dw

@DWiser 

 

You're welcome!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies