ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   what is difference between "=" and "=+" in excel function (https://www.excelbanter.com/excel-programming/371562-what-difference-between-%3D-%3D-excel-function.html)

gaoran

what is difference between "=" and "=+" in excel function
 
what is difference between "=" and "=+" in excel function?

Dave Peterson

what is difference between "=" and "=+" in excel function
 
Lots of people grew up using Lotus 123 where they started formulas with +'s.

+3-abs(a1)
(for instance)

When they shifted to excel, they still remember their 123 rules and include that
+.

It's not necessary.



gaoran wrote:

what is difference between "=" and "=+" in excel function?


--

Dave Peterson

Bob Phillips

what is difference between "=" and "=+" in excel function
 
None. The + is redundant, and is a compatibility throwback to Lotus 1-2-3.
Ditch it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gaoran" wrote in message
...
what is difference between "=" and "=+" in excel function?





All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com