you just need an absolute reference to a1.

from your example

in b2 enter , = a2/$a$1
when you copy down column a,

b3 will be, =a3\$a$1
b4 will be, =a4\$a$1

and so on

--


Gary


"Ernesto" wrote in message
oups.com...
hello, this is my first time here. a friend suggested that you all
could help me out. here is the situation.

i have a set of data which i need to insert a formula for. i need to
insert the formula and make sure that one of the cells that the formula
is using is abolsute and that the other is relative.

example:
I have a list of data in column A. A1 contains the number which needs
to be absolute. A2:A4 contain the data that should be relative. B will
contain the formulas. B2 should be something like this =A2/A1, B3
should be =A3/A1..etc.

I decided to approach this by name A1 as MyCell...but i cant seem to
make a formula which will include the other relative cells...Help!!

thanks!