Hi Stefi,

Many thanks for the help...although it is on the right track, its not quite
doing it. with the formula you have supplied if cell 1 is anything but '1'
then cell 2 remains at '3' if cell 1 is '1' then cell 2 is '2'..

I've tried to modify this formula myself so that i could say it worked.. but
i know nothing about IF commands.

But like i said...definately on the right track - thanks again for your
efforts

Paul


"Stefi" wrote:

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!