Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel |