You are here:

- Home
- Science
- Mathematics
- Advanced Math
- Cell Reference in Excel application.

Advertisement

Dear Prof Janet

http://en.wikipedia.org/wiki/Microsoft_Excel

http://en.wikipedia.org/wiki/Matrix_(mathematics)

Cell Reference is intersection of column,row where data is to be inserted in the cell.

For example : A3 Cell data is 5. Now A3 cell is column 1 and row 3.

Instead of addressing a cell as columnrow i.e. A3 would we had use addressing a cell as rowcolumn, it would have become 3A. Now 3A=5.

In this case, the cell reference is 3A, now if this convention had

been applied instead of the columnrow convention for cell representation, would it had impacted other excel features ?.

Examples : 5C, 4B, 9R instead of C5,B4,R9 respectively.

The Matrix form representation is m rows * n columns.

Example : The notation of a 3 * 2 matrix : A[3,2] where number of

rows = 3 and number of columns = 2. There are total six elements in the matrix. A[2,3] matrix will be 2 rows and 3 columns with number of six elements in the matrix.

In excel, cell representation is A3 where A = Column name and 3 = row number and not 3A. i.e. ColumnRow and not rowcolumn convention.

In this case, the cell reference is 3A, now if this convention had been applied instead of the columnrow convention, a rowcolumn convention for cell representation, would it had impacted other excel features ?.

Example :

E3=7

R3C5=7

E3=R3C5

if i write 3E instead of using E3 and R3C5 cell references

saying 3E=7

Is 3E=E3 ?

3E=R3C5 ?

Awaiting your reply,

Thanks & Regards,

Prashant S Akerkar

I do not know why Excel references cells by (column, row) instead of the conventional (row, column), nor why they chose to use letters for columns and numbers for rows instead of the other way around. Their choice of protocol does not affect the features of the software. It is only a convention for locating data and does not affect how the data are processed.

You cannot reference a cell as 3E instead of E3. If you try, Excel will view it as an error (and ask if you meant to write E3).

If you enter 3E or E3 as data (as opposed to a cell reference), it will be treated as text. Even as text, "3E" ≠ "E3".

Janet

- Add to this Answer
- Ask a Question

Rating(1-10) | Knowledgeability = 10 | Clarity of Response = 10 | Politeness = 10 |

Comment | Dear Prof Janet Thank you. Thanks & Regards, Prashant S Akerkar |

Advanced Math

Answers by Expert:

I can answer questions in Algebra, Basic Math, Calculus, Differential Equations, Geometry, Number Theory, and Word Problems. I would not feel comfortable answering questions in Probability and Statistics or Topology because I have not studied these in depth.

I tutor students (fifth through twelfth grades) and am a Top Contributor on Yahoo!Answers with over 24,000 math solutions.**Publications**

Co-author of An Outline of Scientific Writing: For Researchers With English as a Foreign Language**Education/Credentials**

I have a Bachelor's degree in Applied Mathematics from the University of California at Berkeley.**Past/Present Clients**

George White Elementary School.
Homework Help program at the Ridgewood Public Library, Ridgewood, NJ.
Individual students.