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!