# 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

Sander

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

#### 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
8
Views
200
Replies
6
Views
410
Replies
7
Views
216
Replies
3
Views
242
Replies
9
Views
190

1,140,941
Messages
5,703,299
Members
421,289
Latest member
java

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back