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

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??

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

Use a linked cell.

Then you can use a formula like:

=if(a1=true,firstformulahere,secondformulahere)

(A1 was my linked cell.)

Josh wrote:

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

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

=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


"Josh" wrote:

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??

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

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


"Josh" wrote:

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??