T
T.R.
=IF((G5+J19)=G5,0,+G5+J19)
G5 needs to stay the same and cell J needs to keep adding .
G5 needs to stay the same and cell J needs to keep adding .
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
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
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
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
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
R
RagDyer
Try this:
=IF($G$5+J19=$G$5,0,$G$5+J19)
=IF($G$5+J19=$G$5,0,$G$5+J19)
T
T.R.
You are Awesome man ! thanks alot for helping me ! that is what i needed it
to do !
to do !
D
Dave Peterson
Or even:
=IF(J19=0,0,$G$5+J19)
or:
=($G$5+J19)*(J19<>0)
=IF(J19=0,0,$G$5+J19)
or:
=($G$5+J19)*(J19<>0)