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?

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

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

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

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.

- All formulas begin with an equals sign
**(=)**. - 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. - 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. - 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. - 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

Deeply repair Excel file password and unlock Excel spreadsheet with use Microsoft Excel unlocker password software. You can simply use this software which completely crack Excel sheet password and excel users very easily read Excel worksheet without any trouble.More information-: http://www.msoffice.excelpasswordunlocker.com/

Aug 16, 2010 | Microsoft EXCEL 2004 for Mac

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:

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

- =A1-A2
- =SUM(A1,-A2)

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

This is the link for excel formulaes on microsoft website http://office.microsoft.com/en-us/excel/HP052001271033.aspx

Jun 21, 2009 | Microsoft Excel for PC

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

www.google.com

Jan 14, 2009 | Microsoft Office Excel 2003 for PC

Ist I want to know what type of formulas u use in works

Jan 13, 2009 | Business & Productivity Software

www.youtube.com/watch?v=xOU_hL2_zBo

i havent watched it, but i think it might help. hope it helps, enjoy

i havent watched it, but i think it might help. hope it helps, enjoy

Nov 16, 2008 | Microsoft EXCEL 2004 for Mac

http://office.microsoft.com/en-us/excel/HP030561151033.aspx

check this link for all excel formula

check this link for all excel formula

Sep 23, 2007 | Microsoft Office Standard for PC

Oct 21, 2016 | The Business & Productivity Software

478 people viewed this question

Usually answered in minutes!

No, I was just giving examples of normal looking coordinates (A1) and then the coordinates I'm now receiving (R[-1]C).

When I click on a cell that has a formula, instead of seeing the x and y axis coordinates, I see these strange R[-1]C ones instead. The only way I know which cells the formula is referring to is by double clicking on the cell and it highlights the other cells that comprise the formula.

When I'm typing a formula, clicking on the cells to create the formula, that's when these different coordinates appear- R[-1]C.

I don't see letters on the X-axis as I'm supposed to. I see numbers on the x and y axes. This is affecting old and new documents. It seems like one of the settings was changed.

I tried going into function settings, I still see the R[-1]C type coordinates in the formula bar. What function should it be set at?

When I click on a cell that has a formula, instead of seeing the x and y axis coordinates, I see these strange R[-1]C ones instead. The only way I know which cells the formula is referring to is by double clicking on the cell and it highlights the other cells that comprise the formula.

×