In a timesheet, there is a bonus structure.

If 8 units are attained then each unit is worth 15, below that and each unit
is only worth 10.

At the bottom of the sheet is 'amount of units', 'unit value', 'total value'
, lets call them A, B and C.
How can I get the unit value to automatically adjust?

I've tried adapting other methods on this board but with no avail.
Thanks for your help


--
Jamie Hannon
Cavendish Munro