Not sure what formula to use

[Epsomdave]

I am attempting to calculate a dollar value that is based on a number of units. Each unit has a different dollar value depending on how many units there are. for instance,
if the spreadsheet reports one unit, then I need to return $45
if the spreadsheet reports two units, then I need to return $65 or 1st unit at 45 and 2nd unit at $20.
if the spreadheet reports three units, then I need to return $ 75 or 1st unit at $45, 2nd at $20 and 3rd at $10
all subsequent units 4 and up need to add $10 per additional unit.

Any help would be really appreciated, seems dead simple but the only thing dead appears to be my brain.

[shg]

=sumproduct((a1 > {0,1,2}) * (a1-{0,1,2}) * {45,-25,-10})

[Epsomdave]

Like a charm. Thanks very much.

[shg]

You're welcome.

[arlu1201]

Epsomdave,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.