Repeat Formula

Hi all,

I am having trouble with this.
I am using this formula in J6: =G6*M1+H6*M2+I6*M3

When i move the formula down to below cells it automatically putting this in below cell:
=G7*M2+H7*M3+I7*M4

Where as i need: G7*M1+H7*M2+I7*M3...
G8*M1+H8*M2+I8*M3 down the column.

It is raising the "M" cell by 1 each time where as i need the "M" cells to stay M1, M2, M3.

Hope i have explained ok.

Any help appreciated.

Mick

hello

put $ signs on cells that you don't want to change

Please Login or Register  to view this content.

Wow. Its easy when you know how.

Thank you all for your help.

Mick