You have been given an elegant answer but if it is homework and you must use
IF
=50 + IF(A150, (A1-50)*0.12, 0)
Another non-IF formula is =50+ (A150)*(A1-50)*12
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"daedalus1" wrote in message
...
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