how to program recurring value

L

Leo Kerner

I wish every entry of a colums to be a the same function of the entry
above. How do I do that?
Leo
 
N

Norman Harker

Hi Leo!

Assuming that you have your first formula entered
Select the range covered by the common entry formula
F2
Ctrl + Enter

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
L

Leo Kerner

Thanks, Norm...
Leo

Norman said:
Hi Leo!

Assuming that you have your first formula entered
Select the range covered by the common entry formula
F2
Ctrl + Enter

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
N

Norman Harker

Hi Leo!

Thanks for thanks. The following might be easier and in any event is
very well worth knowing.

If you are entering the same formula in a column for a range that is
parallel to entries on the immediate left or right.

Enter the formula in the first cell.
Point to the bottom right of the entry until you see the +
Double click.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
L

Leo Kerner

Hi, Norman...

I run into a problem doing this in the following scenarios
In Sheet1 I define a few parameters and give them a fixed value. Say C3 is
..02
In Sheet2, I wish to define each entry in row B as
entry_in_cell_above*(1+Sheet1!C3)
so Sheet2 B3 reads B2*(1+Sheet1!C3)

After following your instructions Sheet2 B4 reads B3*(1+Sheet1!C4)
ie, B2 changes to B3, which I want snd
Sheet1!C3 changes to Sheet!C4, which I DO NOT want.

Any suggestions?

Regards,

Leo
 
Top