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