qty to change all to 0

[Ron]

I'm working with a bid sheet with quanties. In the column I have the
qty of 1 and all rolls down the column have part quanties required.
What I'm trying to do is when the qty cell is 0, all cells down the same
column are = to 0, & if I change the qty back to 1 everything is back to
normal.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Don Guillett]

???
try
=if($a$1=0,0,normal) whatever normal is

 

[Dave Peterson]

If you allow the user to type over the formula, I think I'd use a helper column
of cells:

One column for the typed value and one column for the defaults (could be all 0's
if you want).

Then

User Entry Program Default UsedValue
---------- --------------- ------------------
15 0 =if($a$1=0,b9,a9)

With this data in A9:C9.

Then the user could toggle that indicator cell and not lose their typing.