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

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

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

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

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." wrote in message
...
=IF((G5+J19)=G5,0,+G5+J19)

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

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

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"T.R." wrote in message
...
=IF((G5+J19)=G5,0,+G5+J19)

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

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

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
on with J20, J21, J22, and so on. I have been just re-entering the same
formula but keeping "G5" the same in the formula

"Tyro" wrote:

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." wrote in message
...
=IF((G5+J19)=G5,0,+G5+J19)

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

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

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

"RagDyer" wrote:

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"T.R." wrote in message
...
=IF((G5+J19)=G5,0,+G5+J19)

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

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

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

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


RagDyer wrote:

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"T.R." wrote in message
...
=IF((G5+J19)=G5,0,+G5+J19)

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

--

Dave Peterson