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

[Coddie]

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.

 

[Ola]

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

 

[Harlan Grove]

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,"")

 

[Coddie]

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

Coddie

 

[Coddie]

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

coddie