+= in Excel

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
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
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
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.
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828

ADVERTISEMENT

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.

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

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
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(......
 

Watch MrExcel Video

Forum statistics

Threads
1,118,799
Messages
5,574,380
Members
412,589
Latest member
ArtBOM
Top