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 =]