Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 21st 10, 08:29 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 24
Default plus sign before cell reference in formula

what is the difference between this formula:

=+C31*$D$14

and this one:

=C31*$D$14

both formula give the same results. what is the purpose of the plus sign?

  #2   Report Post  
Old January 21st 10, 09:16 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 563
Default plus sign before cell reference in formula

The plus sign serves no useful purpose whatsoever
It does tell us that maybe the originator of the workbook began life as a
Lotus 123 users where formulas began with +. And that they have not yet
found that Excel does not require them (old habits die hard - or not at all)
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"KrispyData" wrote in message
...
what is the difference between this formula:

=+C31*$D$14

and this one:

=C31*$D$14

both formula give the same results. what is the purpose of the plus sign?


  #3   Report Post  
Old July 7th 21, 08:09 AM
Member
 
First recorded activity by ExcelBanter: Jun 2021
Posts: 47
Default Trivia about the + sign

Hello!

Aside from the = sign, you can start a formula by using a + sign. While you can say that this is "useless", the main function of this is to just multiply the whole formula with +1, that's why it appears as if nothing happened.

For the - sign, the inverse is true. It multiples the whole formula by -1, meaning a positive output of a formula becomes negative, and a negative output of a formula becomes positive. This can be useful in a number of applications.


For more tips on excel and financial models, you can check this out. Hope this helps!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What does a plus sign in front of a cell reference mean? KrispyData New Users to Excel 1 January 21st 10 09:32 PM
= sign in formula changes to + when adding a cell or name Steve Excel Discussion (Misc queries) 2 May 19th 09 04:02 PM
How to put + sign in cell, not formula? slp2b Excel Discussion (Misc queries) 1 September 27th 08 05:37 PM
$ sign for absolute reference Explanation pano Excel Worksheet Functions 3 February 14th 07 04:28 PM
Can I reference =, <, or > sign in SUMPRODUCT BobT Excel Discussion (Misc queries) 7 February 16th 05 02:58 PM


All times are GMT +1. The time now is 01:26 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017