"=+"

G

greenlight

New Member
Joined
May 8, 2009
Messages
14
Hi everyone. Can anybody tell me what a + sign after the = indicates? I've seen it several times before. Can't think of an example with it, but it's followed by sometimes a function argument or a sheet name. Not sure if this is some type of add-in that lets you write formulas like this or if this is actual excel functionality. Thanks.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
Hi

The + symbol is usually redundant in this context. If you have the = symbol, you can usually leave out the + symbol and get the same result.
 
Upvote 0
thanks for replying so quickly to the both of you - so you're saying =+today() and =today() is the same thing? why would someone write the formula like that? and wsjackman, if it's just old lotus 123, then we can just assume that if it reads =+ then we can just omit the + and read the regular formula, right?
 
Upvote 0
why would someone write the formula like that?
Click to expand...

My guess would be that if they are used to Lotus 1-2-3, then they are probably in the habit of it.
 
Upvote 0
greenlight said:
Can anybody tell me what a + sign after the = indicates?
Click to expand...
This question has come up many times before on this board, here are just a few links that explain what you are asking about:

http://www.mrexcel.com/forum/showthread.php?t=386224
http://www.mrexcel.com/forum/showthread.php?t=369789
http://www.mrexcel.com/forum/showthread.php?t=342904
http://www.mrexcel.com/forum/showthread.php?t=324439
http://www.mrexcel.com/forum/showthread.php?t=305685
http://www.mrexcel.com/forum/showthread.php?t=204641
http://www.mrexcel.com/forum/showthread.php?t=192132
http://www.mrexcel.com/forum/showthread.php?t=191299
http://www.mrexcel.com/forum/showthread.php?t=177271
http://www.mrexcel.com/forum/showthread.php?t=153317
http://www.mrexcel.com/forum/showthread.php?t=146054
http://www.mrexcel.com/forum/showthread.php?t=93961
http://www.mrexcel.com/forum/showthread.php?t=90614
http://www.mrexcel.com/forum/showthread.php?t=88661
http://www.mrexcel.com/forum/showthread.php?t=73670
http://www.mrexcel.com/forum/showthread.php?t=64748
http://www.mrexcel.com/forum/showthread.php?t=59225
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Question Question
Cell referencing issue
Replies
1
Views
110
RoryA
RoryA
T
  • Solved
Inserting a table into HtmlBody of email in vba
Replies
3
Views
1K
Domenic
D
T
  • Solved
There has to be a simple answer
Replies
3
Views
622
Fluff
Fluff
B
  • Solved
VBA Copy adjacent AND non-adjacent named table columns
Replies
2
Views
227
Bleed_Air
B
Skrej
  • Solved
filtering out zero values from results
Replies
2
Views
394
Skrej
Skrej

Forum statistics

Threads
1,223,896
Messages
6,175,265
Members
452,627
Latest member
KitkatToby

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top