simple formula

[Sander de Geus]

Hello,
I'm trying to make a simple formula in excel without usen macro's.
I want the formula's to be partitionally stationary. meaning:

C= 1 m1 x RDS 9,00 = 9,00 st. This is formula: B3*B1=D3
next row: B4*B1=D4 and so on

RDS 9,00 st/m1
Now when i pull down to copy, excel
C 1,00 m1 9,00 st doesn't leave B1 stationary.
C 1,00 m1 9,00 st how can i get it to do so ?
B 1,10 m1 9,90 st Ther is probably an easy way but i don't
B 1,10 m1 0,00 st see it.
H 0,45 m1 0,00 st
M 2,50 m1 0,00 st

Thanks already

Sander

 

[patrickmuldoon99]

To keep a cell reference stationery, then you need to preceed it with a dollar sign to signify what element (row or column) you want to stay static.

For example

=A1 + B1 dragged down will turn into
=A2 + B2
=A3 + B3

however

=A$1 + B$1 dragged down will turn into
=A$1 + B$1
=A$1 + B$1

Similarly, dragged across ----->>>> this would be

=A1 + B1 = B1 + C1 = C1 + D1

but with dollar signs:

=$A1 + $B1 =$A1 + $B1 =$A1 + $B1


So the dollar sign is what you need

hope this helps

patrick

 

[Sander de Geus]

Thanks Patrick
, just what i needed.
I was using the $ sign, but placed it wrong ($B01 instead of B$01).

Mucho Gracias