Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

relative formula

ResolvedVersion Standard

Stuart has attended:
Excel Introduction course

Relative formula

i would like to know a bit more about relative formula

RE: relative formula

Hi Stuart

Thank you for your question.

A relative reference in a formula is a reference or cell name that changes when the formula is copied to other cells in the spreadsheet.

For example, if you enter a formula in cell C1 that reads =A1*B1, you are asking Excel to look at the cells that are two to the left and one to the left respectively of the cell that the formula is in, and multiply the figures in these two cells together.

If you copied this formula to cell C2, it would still look at the cells that are two to the left and one to the left of cell C2 and multiply the figures in these two cells together. So the formula would change to read =A2*B2.

I hope this helps.
Amanda

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.