check box function?
 

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

check box function?
 

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




--

Regards,

Peo Sjoblom


"scott" wrote in message
...
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