In B1 enter =IF(A1="","",yourformula)

Same for C1 and D1

Select B1:D1 and drag/copy down as far as you wish.

If column A cell is empty, B1:C1 will look blank.

As column A gets data, these formulas will show theit results.


Gord Dibben MS Excel MVP

On Wed, 14 Feb 2007 11:58:20 -0800, Cam1234
wrote:

I have created a data set that is updated every month with new prices. The
prices are entered into a cell, say A1, then the next 3 cells (B1:D1) to the
right use different formulas with that data to give me information I need. I
was wondering if there was a way, so that when I enter new data in A2 for the
next month, the 3 cells to the right of A2 will automatically apply the
formulas from B1:D1 (into B2:D2). Under ToolsOptionsEdit the 'Enable
AutoComplete for Cell Values' and 'Extend Data Rage Formulas and Format' are
checked off. Also, under the ToolsOptionsCalculations tab the 'Automatic'
is also checked off.

Any help on this would be great appreciated, as I am great confused!

Thanks!