software

I can not figure out how to apply a continual formula to a column of figures.
Ex. There is a specific number is cell A1.

I would like to enter a formula of quot;=sum(A4/A1)quot; into cell B4
Then..........................................quot;=su m(A5/A1)quot; into cell B5

How do I get an entire portion of column A to all be divided by cell A1 and
put
the answers in the corresponding B cells ?

Thank you in advance for your time ! Much appreciated !

Audrey wrote:
gt; I can not figure out how to apply a continual formula to a column of
gt; figures. Ex. There is a specific number is cell A1.
gt;
gt; I would like to enter a formula of quot;=sum(A4/A1)quot; into cell B4
gt; Then..........................................quot;=su m(A5/A1)quot; into cell
gt; B5
gt;
gt; How do I get an entire portion of column A to all be divided by cell
gt; A1 and put
gt; the answers in the corresponding B cells ?
gt;
gt; Thank you in advance for your time ! Much appreciated !

Try entering =A4/A$1 in B4 (the SUM() function is redundant) and then
copying down the formula.
Try this:

B4: =A4/$A$1
copy that formula down as far as you need.

Note: the dollar signs in the references lock-in that part of the reference.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Audreyquot; wrote:

gt; I can not figure out how to apply a continual formula to a column of figures.
gt; Ex. There is a specific number is cell A1.
gt;
gt; I would like to enter a formula of quot;=sum(A4/A1)quot; into cell B4
gt; Then..........................................quot;=su m(A5/A1)quot; into cell B5
gt;
gt; How do I get an entire portion of column A to all be divided by cell A1 and
gt; put
gt; the answers in the corresponding B cells ?
gt;
gt; Thank you in advance for your time ! Much appreciated !


Audrey Wrote:
gt; I can not figure out how to apply a continual formula to a column of
gt; figures.
gt; Ex. There is a specific number is cell A1.
gt;
gt; I would like to enter a formula of quot;=sum(A4/A1)quot; into cell B4
gt; Then..........................................quot;=su m(A5/A1)quot; into cell
gt; B5
gt;
gt; How do I get an entire portion of column A to all be divided by cell A1
gt; and
gt; put
gt; the answers in the corresponding B cells ?
gt;
gt; Thank you in advance for your time ! Much appreciated !

In Cell B4, enter the formula

=A4/$A$1

and copy all the way down.

Regards.--
BenjieLop------------------------------------------------------------------------
BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=534703