How do I zero out cells in a table?

  • Thread starter Thread starter lphiekickmydog
  • Start date Start date
L

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
 
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
 
Back
Top