So what you want in G2980 is =IF(yourformula=0,1,yourformula)
And in K2980 you want =IF(youroriginalG2980formula=0,1,"")
--
David Biddulph

"Eden397" wrote in message
...
G2980 is a result of a formula.

"Gary''s Student" wrote:

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