Hello,

Thanks for previous help.

a. Sometimes when I open up a new spreadsheet, the column Headings come
up as labeled: A, B, C,... which is what I want.

Other times, its: 1,2,3,... which is what I don't.

What determines ? What is significance, etc. ?

b. I have a computation in, e.g., Column C, Row 10, which uses the
previous result in Column C, Row 9 summed with whatever is in Row 9,
Columns A and B

Sometimes Columns A and B are just empty.

But the formula grabs what is in the previous Row and Column C.

Thus for blanks in Columns A and B (for any Row), a value appears in
Column C.

For cases where A and B have nothing in them, I would like Column C to
show a blank.

My present formula does not allow this, as it uses the previous Row
value in Column C all the time.

How do I get around this, please ?
An "IF" statement the easiest, or is there a better way ?

Thanks,
Bob


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com