View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chris1bcoo
 
Posts: n/a
Default making a cell zero out after calculation

Lets say I have 3 columns.
I want to deduct from cell C1 when # is put in cell A1 and zero out A1 after
the calculation.
Also I want to add to cell C1 when # is put in cell B1 and zero out B1 after
the calculation.