close

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

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

=IF(A1,quot;checkedquot;,quot;uncheckedquot;)

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

--

Regards,

Peo Sjoblomquot;scottquot; gt; wrote in message
...
gt; Is it possible to but a check box in a ss and then have a formla in a
gt; seperate cell telling you if that check box is checked.
gt; thanks in adavance
gt;
gt; scott

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()