View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default 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?