Is the contents of G2980 a typed-in value or the result of a formula??
--
Gary''s Student - gsnu200757


"Eden397" wrote:

Hi,
I have a formula in cell K2980 stating "=IF(G2980=0,1,"")" . This works
fine but I need to go further with the formula and don't know how. What I
want to do is if G2980 =0, then I want a 1 to show up in K2980 but I also
want the 0 in G2980 to change to a 1. Is this too circular? Thanks, Eden 397