+= in Excel

NBVC

Well-known Member

Joined

Aug 31, 2005

Messages

5,828

• Dec 9, 2005

• #2

In what formula did you see that?

 

Upvote 0

daniels012

Well-known Member

Joined

Jan 13, 2005

Messages

5,219

• Dec 9, 2005

• #3

When you go to enter a formula into a cell with parenthesis, you can hit the "plus sign" on the kepad quicker than the equal sign on the keyboard. It keeps the +=(15*15) in the cell. You can get rid of the plus sign if you like.

Michael

 

Upvote 0

Zack Barresse

MrExcel MVP

Joined

Dec 9, 2003

Messages

10,881

Office Version

1. 365
2. 2010

Platform

1. Windows
2. Mobile
3. Web

• Dec 9, 2005

• #4

Hi, and welcome to the board!

Syntactically, it is incorrect for a formula. Which probably means it's text. The + sign can go after the = sign, but not before; at least not as a formula.

 

Upvote 0

NBVC

Well-known Member

Joined

Aug 31, 2005

Messages

5,828

• Dec 9, 2005

• #5

firefytr said:

Hi, and welcome to the board!

Syntactically, it is incorrect for a formula. Which probably means it's text. The + sign can go after the = sign, but not before; at least not as a formula.

Click to expand...

That's why I was curious to see the formula (if indeed it is a formula).

 

Upvote 0

C

cece

New Member

Joined

Dec 9, 2005

Messages

6

• Dec 9, 2005

• #6

ok thanks!
so what would =+If mean?

 

Upvote 0

NBVC

Well-known Member

Joined

Aug 31, 2005

Messages

5,828

• Dec 9, 2005

• #7

The + is reduntant.

Some people who still use or used Lotus 123 put a + in front of formulas to tell the program that you were entering a formula. Excel uses = instead, but has allowed the use of the + sign, I guess for the sake of attracting the Lotus users so they didn't necessarily have to change this habit.

Try entering a formula like +If(A1="',"","X") and press enter, now go back and look at the formula, you should see =+If...

In Excel, you should really just type =If(......

 

Upvote 0