Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I have an extramely basic question on Excel. What is the difference

between "=" and "=+"

For example, if cell A1 has a number 1,

B1 "= A1" will get a number 1 in cell B1,

B1 "=+A1" will also get a number 1 in cell B1.

Then what is the difference between the two formula?

There is no difference. If you enter a + to start a formula and then click a

cell you get =+, if you enter = you get =.

I suppose the + is acting as a unary +, in the same way as the - in =- is

acting as a unary minus. A unary plus makes no difference to anything. A

unary - negates the value following.

Didn't find what you were looking for?
Find more on Extramely basic question on Excel
Or get search suggestion and latest updates.

Related Topics:

- excel question from a basic excel user
- A very basic excel question about protecting cells
- Excel User Form and Active Excel Work Sheets Question
- Excel User Form and Active Excel Work Sheets Question
- Create Excel Function with Visual Basic
- "Microsoft Visual Basic Help" in Excel 2007
- Visual Basic for Excel Range(Cells Errors
- Basic Swing question
- Threads - Basic question
- Basic UDF Question
- Jakarta POI for Excel Spreadsheets Question
- ms excel 2000 questions
- excel 2000 question
- Excel and VBA Environment questions
- Question about importing Excel.
- DDE with Excel question
- use Excel as Multiple NotePads but some questions
- a few good interview questions for Excel VBA?
- EXCEL Question
- Excel Cell modifiying question
- help requested for using excel's built-in function in coding
- File formats ( Excel 2003 & Excel 97 ) ?
- Copy Excel Object Within Word to Excel
- pasting word table to Excel but needing to match excel
- Need Help In Deleting Duplicate Items in Excel a excel file