+= in Excel

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

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(......
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,834
Messages
5,855,905
Members
431,772
Latest member
dannyboi1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top