| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert the amount in currency into the amount in words? | Excel Discussion (Misc queries) | |||
| Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| Converting amount in figures to amount in words | Excel Discussion (Misc queries) | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Linear Mode
