| 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 |
| 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 | |||
Threaded Mode
