how to decrease cell1 value if i increase cell2 value & visaversa
Try this: Enter
=IF(E2=1,2,IF(E2=0,3,3))
in cell 2, E2 being cell 1.
Regards,
Stefi
€˛apmelectronic€¯ ezt Ć*rta:
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!
|