dragging a formula

[rsx]

if i have numbers in column A and i want column B to represent the numbers in A divided by a number in one particular cell, how can set this formula by dragging?

eg. B1 = A1 / C1
B2 = A2 / C1
B3 = A3 / C1 etc..

Thank you..

 

[gizmo1973]

You've really answered your own question here.
Simply type the equation in B1 =a1/c1 then click and grab hold of the low right hand corner and drag it down as desired, nothing more complicated than that (or if there is a range of numbers double click the low right hand handle to auto fill)

Regards, Phil.

M.U.F.C. Show your true support here:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts

 

[xlbo]

I think th equestion here is about absolute / relative addressing

If I understand correctly, you need to use
=A1/$C$1

as your formula. A search of this forum or XL Help using keywords "Absolute", "Relative" and "Reference" should give you more details

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[gizmo1973]

dohhhh, missed that bit, Geoffs right! (should I say it?)
Sorry!!! Been a longggg day!

Regards, Phil.

M.U.F.C. Show your true support here:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts

 

[rsx]

haha no problem Phil, thanks guys!!