bpeltzer

Many thanks, it seems to work well except when I checked some of the results
with my trusty Casio. For example I have one reading of 586 so it should be
586 - 500 = 86 * 0.12 = 10.32 + 50 = 62.32, it comes up with 62.33, or
another one is 703 which should give a result of 74.36, actually gives a
result of 74.39 which I cannot explain by looking at the formula. Yet
further down the list I have a result of 1041 for the production and the
calculated bonus is 114.92 which is correct. A puzzle indeed.
--
daedalus1


"bpeltzer" wrote:

If the unit volume is in A1, then the bonus is =50 + .12 * (max(0,a1-500))


"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