Conditional formula based on a check box entry

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

Guest

How do I write the formula if check box 1 is checked use cell F1 (as an
example) and if unchecked use cell F2? Seems as though it should be easy,
but can't find the correct sentax...

Many Thanks!

Shawn R
 
Do you have the check box linked to a cell? If so you just need to test that
linked cell.

Assume cell A1 is the linked cell:

=IF(A1,F1,F2)

The linked cell with return either TRUE when the check box is checked or
FALSE when the check box is not checked. So the formula logic is:

IF TRUE F1 ELSE F2
 
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

Conditional Formula Based On A Check Box 1
Formula Based On a Check Box 2
How to use Check Box input in a cell's fomula? 1
conditional formatting update issue 5
Need help with a Multiply Dependent One Cell Formula 11
Conditional Formatting Confusion... 1
Spurious Formula Omits Adjacent Cells 2
cell value based on combo box entry 9

Back
Top