need help copying the formula with a reaccurring cell in the formu

[T.R.]

=IF((G5+J19)=G5,0,+G5+J19)

G5 needs to stay the same and cell J needs to keep adding .

 

[Tyro]

Your formula does not make a lot of sense. For G5+J19 to be equal to G5, if
G5 is not 0, then J19 must be 0; if G5 is 0, then J19 must also be 0
so either way, J19 must be 0 for the condition to be true. Just what are you
trying to accomplish? Remember that a formula returns a value to the cell
containing the formula - it does not change other cells.

Tyro

 

[T.R.]

the formula works with what i have on my page, i was just wondering how to
copy the formula and paste it in the next cell below . here is an example

=IF((G5+J19)=G5,0,+G5+J19) is in one cell. when i copy and paste it
formulates to this =IF((G6+J20)=G6,0,+G6+J20)

It needs to read in the next cell =IF((G5+J20)=G5,0,+G5+J20)
how would you get the cell to copy and paste keeping the G5 and continuing

 

[RagDyer]

Try this:

=IF($G$5+J19=$G$5,0,$G$5+J19)

 

[T.R.]

You are Awesome man ! thanks alot for helping me ! that is what i needed it
to do !

 

[Dave Peterson]

Or even:
=IF(J19=0,0,$G$5+J19)

or:
=($G$5+J19)*(J19<>0)