# Can't see coordinates in Excel Formulas

I'm using Microsoft Office 2004 for Mac. My Excel program is giving me problems in the formula bar. When I type a formula, instead of seeing the coordinates clearly, i.e.: A1+B2+C4, instead I see R[-1]C+R[2]C[1]+R[3]C[2]. I've tried updating Excel and that didn't fix it. Does anyone have any suggestions?

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Sergeant:

An expert that has over 500 points.

Champion:

An expert who has answered 200 questions.

• Expert
Re: Can't see coordinates in Excel Formulas

Type the formula in the workbook cell eg =A1*B2*C4
or select the cells

Posted on Dec 28, 2007

• Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

President:

An expert whose answer got voted for 500 times.

• Master
Re: Can't see coordinates in Excel Formulas

When you type A1+B2+C4, it automatically switches to R[-1]C+R[2]C[1]+R[3]C[2]?

Posted on Dec 28, 2007

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Sergeant:

An expert that has over 500 points.

Champion:

An expert who has answered 200 questions.

• Expert
Re: Can't see coordinates in Excel Formulas

And this is when you have selected a box and simply type something ?

Posted on Dec 28, 2007

0 characters

×

my-video-file.mp4

×

3 Points

## Related Questions:

### What are the formulas in grading the grades uisng microsoft excel

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

1. All formulas begin with an equals sign (=).
2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
3. Other formulas refer to different functions such as SUM, AVERAGE and others.
For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
4. Formulas can be combined with operands.
For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
5. Functions can be nested within each other.
For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

### What is the formulas in computing grades in excel?

Aug 16, 2010 | Microsoft EXCEL 2004 for Mac

### Ms-office

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:
1. =A1-A2
2. =SUM(A1,-A2)
The above formulas refer to cell reference A2 subtracted from A1. As usual, you can use number values instead of cell references.

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

Jul 08, 2009 | Microsoft Office Excel 2003 for PC

### Vlookup in 2004 excel for mac o/s

First make sure there is an "=" sign at the beginning of the formula.  If there is and the formula still shows in the cell go to Preferences and click View.  Make sure the "Formulas" box under Window Options is not checked.

Jun 04, 2009 | Microsoft EXCEL 2004 for Mac

### Excel Formulas

http://office.microsoft.com/en-us/excel/HP030561151033.aspx
check this link for all excel formula

Sep 23, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

478 people viewed this question

Level 3 Expert

Level 3 Expert