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

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

Guest

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??
 
Use a linked cell.

Then you can use a formula like:

=if(a1=true,firstformulahere,secondformulahere)

(A1 was my linked cell.)
 
=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
 
=IF(A1=TRUE,Formula if box IS checked,Formula if NOT checked)
sorry, overlooked that you needed to add formulas...
 
Back
Top