# simple formula

#### Sander de Geus

##### New Member
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

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

#### patrickmuldoon99

##### Active Member
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

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

Mucho Gracias

Replies
3
Views
116
Replies
24
Views
1K
Replies
5
Views
76
Replies
5
Views
96
Replies
2
Views
246

Threads
1,113,919
Messages
5,545,028
Members
410,647
Latest member
bernardazar