Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula
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 |
#2
|
|||
|
|||
On Sat, 10 Sep 2005 15:31:07 -0700, "V" wrote:
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 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 |
#3
|
|||
|
|||
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 Replace@mailinator with @tiscali.co.uk "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 |
#4
|
|||
|
|||
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 "Ron Rosenfeld" wrote: On Sat, 10 Sep 2005 15:31:07 -0700, "V" wrote: 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 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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
Valerie, Glad that helped, but I am not aware of any method to retain the 'improper' fraction. V Wrote: 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 -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |