Calculating a Cost per Amount

%3CLINGO-SUB%20id%3D%22lingo-sub-2044132%22%20slang%3D%22en-US%22%3ECalculating%20a%20Cost%20per%20Amount%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2044132%22%20slang%3D%22en-US%22%3E%3CP%3ETrying%20to%20create%20a%20formula%20that%20will%20calculate%20a%20cost%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%2475%20for%20the%20first%20%242%2C500%20then%20%242.50%20per%20%241%2C000%20(beyond%20the%20%242%2C500)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20any%20help!%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-LABS%20id%3D%22lingo-labs-2044132%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2044215%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20a%20Cost%20per%20Amount%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2044215%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F922583%22%20target%3D%22_blank%22%3E%40Michelle_MBS%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D(75%2BINT((A1-2500)%2F1000)*2.5)*(A1%26gt%3B%3D2500)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Trying to create a formula that will calculate a cost: 

$75 for the first $2,500 then $2.50 per $1,000 (beyond the $2,500)

 

Appreciate any help!

 

 

 

 

1 Reply

@Michelle_MBS 

As variant

 

 

 

=(75+INT((A1-2500)/1000)*2.5)*(A1>=2500)