i want to base a formula off whether a checkbox is filled in

[Josh]

I want to use a check box and have it to base formulas i.e. if the checkbox
is filled in use this formula if notr use that formula how do i do this??

 

[Dave Peterson]

Use a linked cell.

Then you can use a formula like:

=if(a1=true,firstformulahere,secondformulahere)

(A1 was my linked cell.)

 

[ufo_pilot]

=IF(A1=TRUE,"box is checked","box is NOT checked")
edit A1 to where your checkbox is and the comments
btw
TRUE = box is checked
FALSE = box is NOT checked

 

[ufo_pilot]

=IF(A1=TRUE,Formula if box IS checked,Formula if NOT checked)
sorry, overlooked that you needed to add formulas...