Calculation with IF functions
Start a simple worksheet to walk through this example.
In cells A3 to A6 enter your values 275, 350, 510, & 600.
In cell E3 enter 500
In cell E4 enter 0.12
In cell E5 enter 50
In cell B3 paste this formula and then copy to cells B4 to B6.
=IF(A3<$E$3,$E$5,((A3-$E$3)*$E$4)+$E$5)
"daedalus1" wrote:
I have a series of data on production volumes (below). We pay a bonus of min
£50 for upto 500 units of production and then £0.12 per unit above that. I
want to calculate the bonus so it is just a single figure in £s in the column
next to Prod. Any ideas how to do this?
Prod Bonus
275 50
350 50
510 50 + 1.2 = 51.2
600 50 + 12 = 62
Thanks in advance
--
daedalus1
|