"=+"

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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
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

K
  • Question Question
help with formula
Replies
3
Views
87
Peter_SSs
Peter_SSs
L
  • Question Question
Cell referencing issue
Replies
1
Views
126
RoryA
RoryA
S
  • Question Question
If cell matches another cell, apply conditional formatting to another cell
Replies
4
Views
144
SuperX7
S
H
  • Question Question
Help filtering a table using LET, UNIQUE functions
Replies
6
Views
100
Dave Patton
D
T
  • Solved
Inserting a table into HtmlBody of email in vba
Replies
3
Views
1K
Domenic
D

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

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