How can I leave the contents of a cell alone in an IF statement?
This is so simple I cannot believe I can't see the answer. I have a
situation where column A is the current weeks totals (ex: a1 = 6, a2 = 10, a3
= 12). I need to have column b equal the month-to-date totals (b1 = b1+a1,
b2 = b2+a1, b3=b3+a3). I realize this is dealing with circular references,
but I find it hard to believe that a situation like this cannot be easily
resolved. Anyone come across this and find a solution?
|