View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
apmelectronic apmelectronic is offline
external usenet poster
 
Posts: 4
Default how to decrease cell1 value if i increase cell2 value & visaversa

How would i get the value of one cell to increase or decrease as i alter the
value of another cell?

example: cell 1 has a value of '3'..if cell 2 has a value of '1' then i want
cell 1 to change its value to '2'...if cell 2 has a value of '0' then cell 1
will remain at value '3'

if anyone can help..please mail me...many thanks!