Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Extramely basic question on Excel

  Asked By: Ira    Date: Nov 30    Category: MS Office    Views: 2567
  

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?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Roop Kapoor     Answered On: Nov 30

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.




Tagged:        

 
 
 
 

Related Post