Calculating a Cost per Amount

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)