Thanks all for your help I have sorted out the the issue of the wrong
answers. The data I am using came from someone elses spreadsheet and the
data was in whole numbers on the screen but actually had decimals behind it.
Basically it was a formatting error on my part.
--
daedalus1


"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