# += in Excel

#### cece

##### New Member
what does += an excel spreadsheet mean?

### 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).

#### NBVC

##### Well-known Member
In what formula did you see that?

#### daniels012

##### Well-known Member
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
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

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).

#### cece

##### New Member
ok thanks!
so what would =+If mean?

#### NBVC

##### Well-known Member
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(......

Replies
4
Views
89
Replies
15
Views
205
Replies
8
Views
80
Replies
2
Views
255
Replies
2
Views
53