tick box

[Chink!]

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!

 

[Biff]

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

 

[Bob Phillips]

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!]

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!