How do I use a "check(ed) box" as a criteria in an "=if" statement

B

Bill Bromback

I am creating an "=if" statement and would like the formula to be able work
like this: =if(c22="check box", .08*6, 0). Is there a way to use the "check
box" and the "=if" formula in combination like this?
 
L

LanceB

Both the forms checkbox and the controls checkbox have a property called
"linked Cell" place a reference in this box eg A1 and then write your if
statement
if(a1,opt1,opt2)

Note: You can make the linked cell the same cell the checkbox is in and hide
the contents of the cell with custom format ;;;

Lance
 
Top