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