A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » New Users to Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

What does a plus sign in front of a cell reference mean?



 
 
Thread Tools Display Modes
  #1  
Old January 21st 10, 07:17 PM posted to microsoft.public.excel.newusers
KrispyData
external usenet poster
 
Posts: 24
Default What does a plus sign in front of a cell reference mean?

how is the following formula:

=+C31*$D$14

different from

=C31*$D$14?

what is the significance of the plus sign when the results are the same?

thanks!
Ads
  #2  
Old January 21st 10, 08:32 PM posted to microsoft.public.excel.newusers
Dave Peterson
external usenet poster
 
Posts: 35,220
Default What does a plus sign in front of a cell reference mean?

Some people learned about spreadsheets using Lotus 123. Those people used the +
to indicate a formula. And they want to continue using it. It's not necessary.

KrispyData wrote:
>
> how is the following formula:
>
> =+C31*$D$14
>
> different from
>
> =C31*$D$14?
>
> what is the significance of the plus sign when the results are the same?
>
> thanks!


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I copy text with a plus sign at the front? rich Excel Discussion (Misc queries) 2 March 2nd 09 06:17 PM
How to display $ sign in front of: 50 under, 50 over misona1 Excel Discussion (Misc queries) 5 October 8th 08 04:01 AM
How do you make a plus sign appear in front of a number? fairchildbrad Excel Discussion (Misc queries) 3 March 1st 07 12:57 PM
Plus sign in front of a formula marksuza Excel Discussion (Misc queries) 3 October 20th 05 06:34 PM
How do I show a multiplication sign in front of a number accounting beginner Excel Discussion (Misc queries) 8 March 21st 05 03:59 PM


All times are GMT +1. The time now is 02:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.