First unit full price, each one after at half off

Hi everyone! I am very new to Excel (and not that great at math in general), and I'm trying to figure out what seems like a simple problem.

I would like the first unit to cost the full amount, but every unit after that to be half off.
Cost per unit = B2
Number of units = C2
Total Cost = D2

So if there are 4 units with the first one being $48, then the other three would be $24 each, with the total being $120.
If there's only 1 unit, then the total would be $48.

I tried nesting SUM and IF functions, but Excel didn't like the way I did it.

Thanks in advance =]

Try

=(C2+1)*B2/2

Hi,

Welcome to the Forum.

Please use the following formula in D2

=(B2*1)+(C2-1)*(B2*0.5)


B2= Cost Per Unit
C2 = Number of Units
D2 = Total Cost

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you everyone! I ended up using mohamed's formula as it fixed the problem of a total price still being shown even if there were zero units.

Have a wonderful day =]