value changes if over a certain amount - help
 

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

value changes if over a certain amount - help
 

Try this in B2:

=IF(A2=8,15,10)

and then copy down.

Hope this helps.

Pete

On Jan 9, 10:17*am, jamiehannon
wrote:
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

value changes if over a certain amount - help
 

The formular i've put in is =IF(B23=8,15,10)
which does make sense in my head but the cell now reads "Jan-00"

B23 C23 D23 being our A B C
--
Jamie Hannon
Cavendish Munro


"Pete_UK" wrote:

Try this in B2:

=IF(A2=8,15,10)

and then copy down.

Hope this helps.

Pete

On Jan 9, 10:17 am, jamiehannon
wrote:
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

value changes if over a certain amount - help
 

sorry yes i see what i've done it thought it should be a date not a normal
number

works perfectly thanks
--
Jamie Hannon
Cavendish Munro


"Pete_UK" wrote:

Try this in B2:

=IF(A2=8,15,10)

and then copy down.

Hope this helps.

Pete

On Jan 9, 10:17 am, jamiehannon
wrote:
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

value changes if over a certain amount - help
 

Glad to hear it - thanks for feeding back.

Pete

On Jan 9, 12:48*pm, jamiehannon
wrote:
sorry yes i see what i've done it thought it should be a date not a normal
number

works perfectly thanks
--
Jamie Hannon
Cavendish Munro



"Pete_UK" wrote:
Try this in B2:

=IF(A2=8,15,10)

and then copy down.

Hope this helps.

Pete

On Jan 9, 10:17 am, jamiehannon
wrote:
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- Hide quoted text -

- Show quoted text -