check a checkbox in a formula

B

big t

Hi everyone,

I need to check a checkbox in a formula - something like this:

=if(mycheckbox, "Yes", "No")

I'm using the ActiveX style checkbox - ie the one from the Control Toolbox.

Any ideas?

TIA
big t
 
B

Bob Phillips

No can do. The best you can do is to link the checkbox to a cell and check
that

=IF(G1,"Yes","No")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top