Using a checkbox to change a formula
hi all
I have a checkbox, cbxUseNewSystem on my worksheet. When the box is
checked, I need to have a long CSE formula in cells G10:G30. Without the
boring details, its structure is:
{=IF(code here) & IF(more code here) & IF(even more code here)}
If the checkbox is NOT checked, the CSE formula in G10:G30 needs to be the
same as above, but with the last IF removed, like:
{=IF(code here) & IF(more code here)}
I'm just learning code, and I'm a bit confused as to how to do this? Any
help will be appreciated.
Giselle
|