Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help determining formula
This should be simple for the pros but I've spent hours researching and can
not come up with a solution. Lets say you have 3 columns A, B & C. 10 rows of numbers in Column A and 10 rows of numbers in column B, what is the formula for A/B to appear in column C for all ten rows. In actuality, I have over 1000 rows of data and I dont want to enter =SUM(A1/B1) in each row of column C. What is the formula that will automatically compute A/B for many rows to appear in C. Your help will be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help determining formula
In C1 enter
=Sum(A1/B1) then reselect the cell. in the lower right corner of the highlight, you should see a small square. Double click on it and it should fill down. -- Regards, Tom Ogilvy " wrote in message ... This should be simple for the pros but I've spent hours researching and can not come up with a solution. Lets say you have 3 columns A, B & C. 10 rows of numbers in Column A and 10 rows of numbers in column B, what is the formula for A/B to appear in column C for all ten rows. In actuality, I have over 1000 rows of data and I dont want to enter =SUM(A1/B1) in each row of column C. What is the formula that will automatically compute A/B for many rows to appear in C. Your help will be greatly appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help determining formula
Worked perfectly. Thanks Tom for the help!!!!!!!!!!!!
"Tom Ogilvy" wrote in message ... In C1 enter =Sum(A1/B1) then reselect the cell. in the lower right corner of the highlight, you should see a small square. Double click on it and it should fill down. -- Regards, Tom Ogilvy " wrote in message ... This should be simple for the pros but I've spent hours researching and can not come up with a solution. Lets say you have 3 columns A, B & C. 10 rows of numbers in Column A and 10 rows of numbers in column B, what is the formula for A/B to appear in column C for all ten rows. In actuality, I have over 1000 rows of data and I dont want to enter =SUM(A1/B1) in each row of column C. What is the formula that will automatically compute A/B for many rows to appear in C. Your help will be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determining if a range of cells is missing a formula | Excel Worksheet Functions | |||
Variable determining formula | Excel Discussion (Misc queries) | |||
Formula for determining sales commission | Excel Worksheet Functions | |||
need help with determining a formula | Excel Worksheet Functions | |||
Determining whether selected cell has value or formula? | Excel Programming |