formulas

[antonov]

Hello everybody:
is it possible to have a macro or whatever to "replicate" the formulas in
the next row so that I have the formulas only in the cells I am actually
going to use and not on all the empty rows?

[Gary''s Student]

You can make the formula cells "invisible". Suppose you have data in columns
A & B. In C1 you have =A1+B1. You would have to copy the formula down to
cover the A's and B's you have entered.

Instead enter =IF(A1="","",A1+B1) in C1 and copy this down. The formula
will be blank until you put non-blank values in A,B
--
Gary''s Student


"antonov" wrote:

> Hello everybody:
> is it possible to have a macro or whatever to "replicate" the formulas in
> the next row so that I have the formulas only in the cells I am actually
> going to use and not on all the empty rows?
>
>
>