How do I zero out cells in a table?

[lphiekickmydog]

Good Afternoon Everyone,

Here's the deal: I have a cell which I use as
an "on/off" switch, and when I make the value of that
cell = 0 (False), I want all the cell values in a table
in the same spreadsheet to turn to zero (or maybe become
blank). Does anyone know how to go about doing that?

Thanks a lot,
Vivek

 

[CLR]

Hi Vivek.........

Assuming A1 is your "switch" cell, and all the cells you want to switch on
and off contain formulas, then you can just wrap each of them in an IF
statement to accomplish what you want.........

=IF(A1=0,"",YourCellsNormalFormula)


Vaya con Dios,
Chuck, CABGx3