Applying a function to multiple cells automaically

[Linz]

Quite a basic question that I'm sure there is an easy answer to.

Have a basic function (=D5*(1-E5) that shows a discounted value for an
amount in D5 by the percentage in E5.

How can I apply the same function to rows below without re-typing the
function for each line. ie. =D6*(1-E6) etc.

 

[T. Valko]

Here's one way:

Suppose cell G5 contains this formula: =D5*(1-E5)
Select cell G5
In the lower right hand corner of the selected cell you'll notice a little
black square. This is called the fill handle.
Hover the mouse over the fill handle. The cursor will change from a "fat" +
sign to a "skinny" + sign.
When the cursor changes to a skinny + sign left click and hold then drag
down the column as far as needed.
The formulas (and cell formats) will be copied with the references
incrementing as desired.

 

[Linz]

Worked great Biff. Thanks

Here's one way:

Suppose cell G5 contains this formula: =D5*(1-E5)
Select cell G5
In the lower right hand corner of the selected cell you'll notice a little
black square. This is called the fill handle.
Hover the mouse over the fill handle. The cursor will change from a "fat"
+ sign to a "skinny" + sign.
When the cursor changes to a skinny + sign left click and hold then drag
down the column as far as needed.
The formulas (and cell formats) will be copied with the references
incrementing as desired.

 

[T. Valko]

You're welcome!

Here's another tip about using the fill handle...

This will only work for copying down a column, won't work for copying across
a row...

If there is data on either side of the selected cell and it's a contiguous
block, double clicking the fill handle will also copy down until it
encounters an empty cell where it will automatically stop.