Home |
Search |
Today's Posts |
#1
|
|||
|
|||
tick box
Hello
I am making a timesheet to record working hours Would it be possible to use a tick box ( I know how to add this to a cell) to return a particular value in another cell? I would like a user to be able to tick a box to indicate annual leave lets say in cell B9 and by doing so return a value of 8 hours worked that day in cell B10. Not ticking the box returns value of zero, or rather adds zero to B10 (B10 currently has the formula to total the hours worked for that day) many thanks CH! |
#2
|
|||
|
|||
Hi!
You can put a checkbox "in" cell B9 and link the checkbox to the same cell. Set the font color to be the same as the fill color because when checked or unchecked, B9 will return either TRUE or FALSE. Now, add this to the current formula in B10: +8*B9 Biff "Chink!" wrote in message ... Hello I am making a timesheet to record working hours Would it be possible to use a tick box ( I know how to add this to a cell) to return a particular value in another cell? I would like a user to be able to tick a box to indicate annual leave lets say in cell B9 and by doing so return a value of 8 hours worked that day in cell B10. Not ticking the box returns value of zero, or rather adds zero to B10 (B10 currently has the formula to total the hours worked for that day) many thanks CH! |
#3
|
|||
|
|||
Assuming that your tick box is a special font, Marlett say, with a value of
also say 'a', then use =(B9="a")*8 -- HTH RP (remove nothere from the email address if mailing direct) "Chink!" wrote in message ... Hello I am making a timesheet to record working hours Would it be possible to use a tick box ( I know how to add this to a cell) to return a particular value in another cell? I would like a user to be able to tick a box to indicate annual leave lets say in cell B9 and by doing so return a value of 8 hours worked that day in cell B10. Not ticking the box returns value of zero, or rather adds zero to B10 (B10 currently has the formula to total the hours worked for that day) many thanks CH! |
#4
|
|||
|
|||
Thanks for your reply
B10 is formatted as [h]:mm so +8*B9 added to the end of the formula returns a value of 192 hours when the box is ticked Thats clearly not right.... The full formula is =SUM((B5-B4)+(B7-B6))+8*B9 all the cells are formatted as [h]:mm CH! "Biff" wrote in message ... Hi! You can put a checkbox "in" cell B9 and link the checkbox to the same cell. Set the font color to be the same as the fill color because when checked or unchecked, B9 will return either TRUE or FALSE. Now, add this to the current formula in B10: +8*B9 Biff "Chink!" wrote in message ... Hello I am making a timesheet to record working hours Would it be possible to use a tick box ( I know how to add this to a cell) to return a particular value in another cell? I would like a user to be able to tick a box to indicate annual leave lets say in cell B9 and by doing so return a value of 8 hours worked that day in cell B10. Not ticking the box returns value of zero, or rather adds zero to B10 (B10 currently has the formula to total the hours worked for that day) many thanks CH! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tick a reference automatically | Excel Discussion (Misc queries) | |||
how to hide section of worksheet based on a condition (e.g. tick . | Excel Discussion (Misc queries) | |||
Setting Major tick to none on charts is not working, is it a bug? | Charts and Charting in Excel | |||
how I can insert a "tick" symbol | Excel Worksheet Functions | |||
Scatter chart x axis tick mark lables | Charts and Charting in Excel |