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