Jan 08 2021 09:21 AM
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!
Jan 08 2021 09:56 AM
@Michelle_MBS
As variant
=(75+INT((A1-2500)/1000)*2.5)*(A1>=2500)