LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Determining if a range of cells is missing a formula Bob Excel Worksheet Functions 6 December 20th 06 04:00 PM
Variable determining formula natelr Excel Discussion (Misc queries) 2 June 28th 06 12:27 AM
Formula for determining sales commission Doug Excel Worksheet Functions 2 January 3rd 06 09:50 PM
need help with determining a formula Cal Excel Worksheet Functions 2 November 11th 05 01:49 PM
Determining whether selected cell has value or formula? John Wirt Excel Programming 3 July 31st 03 04:19 AM


All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"