formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!

C

Coolchick

in my spreadsheet when i fill down the formula i want it to use one cell and
mulitply it by the row.

How do i do this, please help its driving me mad!
 
N

Niek Otten

Use

=A$1*A2 and fill down

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| in my spreadsheet when i fill down the formula i want it to use one cell and
| mulitply it by the row.
|
| How do i do this, please help its driving me mad!
 
D

David Biddulph

Go into Excel help and look at the difference between absolute and relative
addressing for cell references.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 5
conditional formatte date in a1 calculate the date in A2 3
Avoiding redundant calculations 7
Referencing cells in consecutive rows 2
VBA Coding Help for Beginner 0
Automatically populating cells down a row 8
MATH COMPUTAION 6

Top