Formula Based On a Check Box

[Brad Wolosz]

Hi All

Is it possible to have excel pick a formula based on the value of
check box

I would like to create a worksheet with 6 check boxes for th
developers tool box.
Each check box would pick one of two formula sets. Each formula se
would contain two formulas. Each check box would contain a differen
cell set

Example


Check Box #1
if check box "X" is checked exicute formula set (1A)
Formula set (1A) includes formulas (1a) & (2a)
if check box "X" is not checked exicute formula set (2A)
Formula set (2A) includes formulas (3a) & (4a)
Check Box #2
if check box "Y" is checked exicute formula set (1B)
Formula set (1B) includes formulas (1b) & (2b)
if check box "Y" is not checked exicute formula set (2B)
Formula set (2B) includes formulas (3b) & (4b)

and so on for each check box

Any and all help would be greatly appreciated

Thank You

Bradley Wolos

 

[Thomas [PBD]]

Brad,

You would like this to be a Formula, such that you could enter into a cell
.... similar to =SUM(). If so, I dont believe that you can do this. However,
you are able to place VBA scripting against the check box, to evaluate
whether it is checked or not and have a script run the formulas.

 

[Carim]

Hi,

Among many possibilities, you could have a table, designed in a
separate area, where all the cases are listed and repective
calculations performed ...

Then, based on the checkboxes, just have a vlookup(yourtable) to bring
back the adequate result ...

HTH