View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Nobody@nobodieshome.com is offline
external usenet poster
 
Posts: 2
Default 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.