B
Brad Wolosz
Hi all
Is there a way to set a conditional formula based on a check bo
created thru the developer tool box
I would like to creat a work sheet that has ( 6 ) check boxes
When the check box is checked it call for a formula set
When it is unchecked it calls for a different formula set
Each formula set would contain a minimum of ( 2 ) formulas
Example
Check Box #1 = ( X )
When Check Box ( X ) is checked it uses formula set (A1)
Formula set (A1) has formula (a1) & (a2)
When Check Box ( X ) is unchecked it uses formula set (A2)
Formula set (A2) has formula (a3) & (a4)
Check Box #2 = ( Y )
When Check Box ( Y ) is checked it uses formula set (B1)
Formula set (B1) has formula (b1) & (b2)
When Check Box ( Y ) is unchecked it uses formula set (B2)
Formula set (B2) has formula (b3) & (b4)
Any Help on this issue would be greatly appreciated
Thanks in advance for the help
Bradley Wolos
Is there a way to set a conditional formula based on a check bo
created thru the developer tool box
I would like to creat a work sheet that has ( 6 ) check boxes
When the check box is checked it call for a formula set
When it is unchecked it calls for a different formula set
Each formula set would contain a minimum of ( 2 ) formulas
Example
Check Box #1 = ( X )
When Check Box ( X ) is checked it uses formula set (A1)
Formula set (A1) has formula (a1) & (a2)
When Check Box ( X ) is unchecked it uses formula set (A2)
Formula set (A2) has formula (a3) & (a4)
Check Box #2 = ( Y )
When Check Box ( Y ) is checked it uses formula set (B1)
Formula set (B1) has formula (b1) & (b2)
When Check Box ( Y ) is unchecked it uses formula set (B2)
Formula set (B2) has formula (b3) & (b4)
Any Help on this issue would be greatly appreciated
Thanks in advance for the help
Bradley Wolos