simple formula

Sander de Geus

New Member
Joined
Feb 13, 2006
Messages
11
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
 

Some videos you may like

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
Joined
Jun 27, 2006
Messages
345
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
Joined
Feb 13, 2006
Messages
11
Thanks Patrick
, just what i needed.
I was using the $ sign, but placed it wrong ($B01 instead of B$01).

Mucho Gracias
 

Watch MrExcel Video

Forum statistics

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