Conditional formula based on a check box entry
 

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

Conditional formula based on a check box entry
 

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

--
Biff
Microsoft Excel MVP


"Shawn" wrote in message
...
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