Ask Experts Questions for FREE Help !
Ask
    golady9's Avatar
    golady9 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Nov 26, 2009, 09:17 AM
    spreadsheet division values in 2 COLUMNS
    Hi
    How to do division of column 5 and column 3 ?
    Thanks
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Nov 26, 2009, 09:34 AM
    =E2/C2

    Or vice versa

    In a spreadsheet columns are designated by letters, rows by numbers. Easier to refer to them that way, so you would enter that formula in another columns in Row 2. If you copy the formula down a column it will adjust the row automatically.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Formula entry for division of columns in multiple rows [ 3 Answers ]

I'm relative new to Excel having just used it as a lined sheet of paper for listing things. I'm trying to develop an Excel spreadsheet for tracking my car's mileage. Thus far I'm using a basic sheet with 4 columns - designated A=date, B=Miles travelled, C= Gallons used, and D= the computed MPG...

Transpose rows into columns in a excel spreadsheet [ 3 Answers ]

Can anyone help 1) how to transpose the data in rows into columns and columns into rows in a Excel spread sheet? 2) how to change the numerical order of data in rows/ columns in a Excel spread sheet? i.e.. from the first row to last row and last row to first row ? Thank "U'

Default values in an Escel spreadsheet [ 3 Answers ]

I am used to doing this in Access but don't see how to do it in Excel. And, of course, nothing is easy to find any more in the 2007 version of the program. I want the a cell in a row to auto enter a value when people are doing simple data entry into a spreadsheet. I do not, of course, want...

Filter from 2 Columns (Unique values) in Excel [ 1 Answers ]

I need to filter from both these sets of data in excel Set 1 Set 2 ----------------------- 986 Buchanan Dodsworth 563 67 789 Buchanan 235 689 Dodsworth 789 143

View more questions Search