Addind cell together with a rest.
 

I would like to add two cells together with a rest prevision to 0. My rest is
the letter R, every time R is present in a cell it rest the value back to 0.
eg I want to add cell b19 an c18 together but b19 has an R(for rest), I want
c19 were the formula will be to be 0. Here is the formula that I am using but
it keeps add c18. +IF(B19="R",0,+b19)+c18.
Can some on help me?
Rodger

Addind cell together with a rest.
 

You were pretty close, try this one.........

=IF(B19="R",0,B19+C18)

Vaya con Dios,
Chuck, CABGx3


"Rodger" wrote:

I would like to add two cells together with a rest prevision to 0. My rest is
the letter R, every time R is present in a cell it rest the value back to 0.
eg I want to add cell b19 an c18 together but b19 has an R(for rest), I want
c19 were the formula will be to be 0. Here is the formula that I am using but
it keeps add c18. +IF(B19="R",0,+b19)+c18.
Can some on help me?
Rodger

Addind cell together with a rest.
 

Thank you it worked.

"CLR" wrote:

You were pretty close, try this one.........

=IF(B19="R",0,B19+C18)

Vaya con Dios,
Chuck, CABGx3


"Rodger" wrote:

I would like to add two cells together with a rest prevision to 0. My rest is
the letter R, every time R is present in a cell it rest the value back to 0.
eg I want to add cell b19 an c18 together but b19 has an R(for rest), I want
c19 were the formula will be to be 0. Here is the formula that I am using but
it keeps add c18. +IF(B19="R",0,+b19)+c18.
Can some on help me?
Rodger

Addind cell together with a rest.
 

You're quite welcome, thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3



"Rodger" wrote:

Thank you it worked.

"CLR" wrote:

You were pretty close, try this one.........

=IF(B19="R",0,B19+C18)

Vaya con Dios,
Chuck, CABGx3


"Rodger" wrote:

I would like to add two cells together with a rest prevision to 0. My rest is
the letter R, every time R is present in a cell it rest the value back to 0.
eg I want to add cell b19 an c18 together but b19 has an R(for rest), I want
c19 were the formula will be to be 0. Here is the formula that I am using but
it keeps add c18. +IF(B19="R",0,+b19)+c18.
Can some on help me?
Rodger

Addind cell together with a rest.
 

Or if you want to monitor for an "R" in either cell try nesting 2 IFs like
this:

=IF((B19="R"),0,IF(C18="R",0,B19+C18))

"Rodger" wrote:

I would like to add two cells together with a rest prevision to 0. My rest is
the letter R, every time R is present in a cell it rest the value back to 0.
eg I want to add cell b19 an c18 together but b19 has an R(for rest), I want
c19 were the formula will be to be 0. Here is the formula that I am using but
it keeps add c18. +IF(B19="R",0,+b19)+c18.
Can some on help me?
Rodger

Addind cell together with a rest.
 

Rodger

=IF(B19="R",0,(B19+C18))

Entered in C19


Gord Dibben MS Excel MVP

On Thu, 7 Dec 2006 07:55:01 -0800, Rodger
wrote:

I would like to add two cells together with a rest prevision to 0. My rest is
the letter R, every time R is present in a cell it rest the value back to 0.
eg I want to add cell b19 an c18 together but b19 has an R(for rest), I want
c19 were the formula will be to be 0. Here is the formula that I am using but
it keeps add c18. +IF(B19="R",0,+b19)+c18.
Can some on help me?
Rodger

Addind cell together with a rest.
 

I found another problem with the formula. When cell b19 has a zero in that
cell it will not add cell c18, it just puts a zero in cell c19.
Any help will be much apperciated.

"CLR" wrote:

You're quite welcome, thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3



"Rodger" wrote:

Thank you it worked.

"CLR" wrote:

You were pretty close, try this one.........

=IF(B19="R",0,B19+C18)

Vaya con Dios,
Chuck, CABGx3


"Rodger" wrote:

I would like to add two cells together with a rest prevision to 0. My rest is
the letter R, every time R is present in a cell it rest the value back to 0.
eg I want to add cell b19 an c18 together but b19 has an R(for rest), I want
c19 were the formula will be to be 0. Here is the formula that I am using but
it keeps add c18. +IF(B19="R",0,+b19)+c18.
Can some on help me?
Rodger

Addind cell together with a rest.
 

Maybe this is what you need...........

=IF(ISNUMBER(B19),B19+C19,IF(B19="R",0,"Condition not defined"))

Vaya con Dios,
Chuck, CABGx3



"Rodger" wrote:

I found another problem with the formula. When cell b19 has a zero in that
cell it will not add cell c18, it just puts a zero in cell c19.
Any help will be much apperciated.

"CLR" wrote:

You're quite welcome, thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3



"Rodger" wrote:

Thank you it worked.

"CLR" wrote:

You were pretty close, try this one.........

=IF(B19="R",0,B19+C18)

Vaya con Dios,
Chuck, CABGx3


"Rodger" wrote:

I would like to add two cells together with a rest prevision to 0. My rest is
the letter R, every time R is present in a cell it rest the value back to 0.
eg I want to add cell b19 an c18 together but b19 has an R(for rest), I want
c19 were the formula will be to be 0. Here is the formula that I am using but
it keeps add c18. +IF(B19="R",0,+b19)+c18.
Can some on help me?
Rodger