View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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