check box function?

S

scott

Is it possible to but a check box in a ss and then have a formla in a
seperate cell telling you if that check box is checked.
thanks in adavance

scott
 
P

Peo Sjoblom

Yes, if you link the check box to for instance A1 then this formula will do
it

=IF(A1,"checked","unchecked")

having said that, the linked cell returns TRUE or FALSE where TRUE is
checked
 
Top