check a checkbox in a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF checkbox is checked/unchecked, Cell.value = yes/no 3
Check Boxes 1
Can I update a date formula only if checkbox changes? 1
Macro to clear checkboxes 5
Change formulas in a column based on a selection. 3
Add a checkbox to a spreadsheet 2
check and uncheck macro 5
Checkbox Next to Mail Message - How Do I Make It Visible? How Do I Make a Check Appear? 1

Back
Top