Thank you. This was very helpful. I used your info and completed all of my
remaining columns of data. (I had to put in several additional fractions
multiplying the denominator by different terms.) I have one last quick
question:

Is there anyway to keep excel from reducing the fraction to lowest terms?
(Ie - 2/4 to 1/2)

Thank you so much for your assistance - I really appreciate you taking the
time to answer my question.

Valerie

"Bryan Hessey" wrote:


The easy way,

put your Numerator in cell A1 (ie, click on cell A1 and type 5 then
press enter)

in cell A3 put a 3 (the first denominator)
click on cell A3 and hold the CTRL key down and drag the small square
(which becomes a + sign) in the bottom right corner of the highlight to
row 101 (the last denominator required).

In cell B3 put

=$A$1/A3

where $a says ALWAYS use column A, $1 says ALWAYS use row 1.

click on cell B3, and double-click the small square (the + sign) in the
highlight.

This should copy the formula to B101

click on the B header in column B to highlight the whole column, and
then Rightmouse that B and select Format Cells
In the Number tab, select Fraction and select (say) Up to 3 digits

Is this what you require?









V Wrote:
Thanks for the response. I don't know what to do with the formulas. I
have
to put this together for a class and don't know anything about excel.
I
thought I could figure it out, but it is much harder than I thought.

Thanks,
V

"PY & Associates" wrote:

Is this alright?

for i = 1 to NrOfRows
cells(i, AnsCol)=function(cells(i,VarCol))
next i

"V" wrote in message
...
I need to create an excel spreadsheet using a math equation that
has one
variable that is the denominator of a fraction. I need to be able
to
change
the variable every row. Ie - starting variable is 3 and last
variable is
101. Any tips would be greatly appreciated!! Thank you





--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=466542