Formula

V

V

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
 
R

Ron Rosenfeld

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
Click to expand...

A
5 =CONSTANT/(ROW()-2)

As you copy/drag the formula down, the ROW()-2 parameter will increment by one
for each row. Adjust the 2 for whatever row your formula starts in.



--ron
 
S

Sandy Mann

Are the formulas in consecutive rows? If so then us the ROW() function to
supply the denominators.

For example, starting in Row 10 if the formula is the sum od A10, B10 & C10
divided by 3 then

=SUM(A10:C10)/(ROW()-ROW($A$7))

will provide the answer and it will index the denominator as it is dragged
down the column.

(ROW()-7) would work just as well but it will go wrong if a row in inserted
or deleted.

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
 
V

V

Thanks for the response. I actually needs the very basics on how to even put
the formula in excel. I am doing this for a class and have no idea how to
use excel. I thought it would be easier than it is.

Thanks,
V
 
P

PY & Associates

Is this alright?

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

V

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
 
B

Bryan Hessey

The easy way,

put your Numerator in cell A1 (ie, click on cell A1 and type 5 the
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 squar
(which becomes a + sign) in the bottom right corner of the highlight t
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 th
highlight.

This should copy the formula to B101

click on the B header in column B to highlight the whole column, an
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

V

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
 
B

Bryan Hessey

Valerie,

Glad that helped, but I am not aware of any method to retain the
'improper' fraction.
 
Top