Addind cell together with a rest.

[Guest]

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

 

[Guest]

Thank you it worked.

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

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

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

You're quite welcome, thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3

 

[Gord Dibben]

Rodger

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

Entered in C19


Gord Dibben MS Excel MVP

 

[Guest]

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.

 

[Guest]

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

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

Vaya con Dios,
Chuck, CABGx3