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
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