Working with check boxes

H

Haleigh

Dear Someone Who Can Help,

I am new to Excel and have been asked to develop a
timesheet. It should calculate overtime hours only if the
employee is eligible. Using the Forms Toolbar, I've added
a tickbox named "OtApplies". However, I can't figure out
how to write the formula to refer to the tickbox result in
my cell formula. I have tried the following:

=IF(OtApplies=1,SUM(P9-Q9)

Can anyone advise?

Thank you!
 
B

Biff

Hi Haleigh!

You need to link the checkbox to a cell. Right click the
checkbox object and select Format Control. In the cell
link box, enter a cell that will hold the value TRUE if
checked, FALSE if unchecked.

Then use that linked cell to determine if the OT applies:

=IF(A1=TRUE, apply OT, do not apply OT)

You can hide the TRUE or FALSE value by using conditional
formatting to set the text color to the same as the
background color.

Biff
 
Top