How do you copy a cell formula down a column without displaying n.
 

I want to insert a formula into my worksheet and copy it down the column
without displaying anything in each cell until a value is established.
Example would be
A3-A2+A1 would be the formula I want the answer to show up in cell A4. I
want to copy the formula from A5 down to A25, but I don't want the result of
cell A4 to show up in each cell.

Do you mean? :

=IF(OR(ISNUMBER(A3),ISNUMBER(A2),ISNUMBER(A1)),A3-A2+A1,"")
'AND' instead of 'OR' if all cells must be numbers.

Ola Sandstrom

"Ola" wrote...
Do you mean? :

=IF(OR(ISNUMBER(A3),ISNUMBER(A2),ISNUMBER(A1)), A3-A2+A1,"")
'AND' instead of 'OR' if all cells must be numbers.

Alternatively, 'OR' semantics:
=IF(COUNT(A1:A3)=1,A3-A2+A1,"")

'AND' semantice:
=IF(COUNT(A1:A3)=3,A3-A2+A1,"")

Yes! It was exactly what I needed. Thank you for your time and assistance.

Coddie

"Harlan Grove" wrote:

"Ola" wrote...
Do you mean? :

=IF(OR(ISNUMBER(A3),ISNUMBER(A2),ISNUMBER(A1)), A3-A2+A1,"")
'AND' instead of 'OR' if all cells must be numbers.

Alternatively, 'OR' semantics:
=IF(COUNT(A1:A3)=1,A3-A2+A1,"")

'AND' semantice:
=IF(COUNT(A1:A3)=3,A3-A2+A1,"")

Thank you so much! It worked! I really appreciate your assistance!

coddie

"Ola" wrote:

Do you mean? :

=IF(OR(ISNUMBER(A3),ISNUMBER(A2),ISNUMBER(A1)),A3-A2+A1,"")
'AND' instead of 'OR' if all cells must be numbers.

Ola Sandstrom