If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#11




=+SUM
You're welcome!
 Biff Microsoft Excel MVP "FJ" > wrote in message ... > Hi, thank you very much for your response. > > > "T. Valko" wrote: > >> The plus sign was used to enter a formula in other spreadsheet >> applications >> like Lotus 123. Some of those old spreadsheet users do it by force of >> habit. >> Excel accepts it for compatibility but it has no effect one way or >> another. >> >> Try entering this formula in Excel in cell B1: >> >> +SUM(A1:A10) >> >> Excel will simply add the equal sign to the formula: >> >> =+SUM(A1:A10) >> >>  >> Biff >> Microsoft Excel MVP >> >> >> "FJ" > wrote in message >> ... >> > Hi, I have a question: I was given a spreadsheet to work on and all >> > the >> > SUM >> > formulas have the following format: =+SUM(A1:A10). I have never seen >> > this >> > before. Does the + sign before SUM mean anything and if so, what? It >> > doesn't seem to make a difference when it is removed. Sorry if this is >> > a >> > really basic question. I have just never seen this before and I am >> > curious. >> > >> > Thanks in advance for any information. >> >> >> . >> 
Ads 
#12




=+SUM
"+" sign is near to numeric pad and that's why often used instead of "="
If you would insert a formula like: +sum(1,1) it would automatically convert to: =+sum(1,1)  Thanx & Best Regards, Faraz! "FJ" wrote: > Hi, I have a question: I was given a spreadsheet to work on and all the SUM > formulas have the following format: =+SUM(A1:A10). I have never seen this > before. Does the + sign before SUM mean anything and if so, what? It > doesnâ€™t seem to make a difference when it is removed. Sorry if this is a > really basic question. I have just never seen this before and I am curious. > > Thanks in advance for any information. 
#13




=+SUM
On Thursday, February 18, 2010 at 11:51:01 AM UTC+3, Faraz A. Qureshi wrote:
> "+" sign is near to numeric pad and that's why often used instead of "=" > If you would insert a formula like: > +sum(1,1) > it would automatically convert to: > =+sum(1,1) >  > Thanx & Best Regards, > > Faraz! > > > "FJ" wrote: > > > Hi, I have a question: I was given a spreadsheet to work on and all the SUM > > formulas have the following format: =+SUM(A1:A10). I have never seen this > > before. Does the + sign before SUM mean anything and if so, what? It > > doesnâ€™t seem to make a difference when it is removed. Sorry if this is a > > really basic question. I have just never seen this before and I am curious. > > > > Thanks in advance for any information. thnks ....... ......its a simple answer for that question..... so that we can + instead of = 
Thread Tools  
Display Modes  

