ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What is purpose of + sign in formula "=+Q290*10" (https://www.excelbanter.com/excel-discussion-misc-queries/207519-what-purpose-sign-formula-%3D-q290%2A10.html)

Sasser

What is purpose of + sign in formula "=+Q290*10"
 
If I didn't have the + sign in the formula, wouldn't I get the same result?

Jim Thomlinson

What is purpose of + sign in formula "=+Q290*10"
 
Yes the plus sign is not required... It was probably entered that was as a
matter of convenience. Instead of typing the equal sign they just typed the
plus. XL inserted the equal sign on it's own.
--
HTH...

Jim Thomlinson


"Sasser" wrote:

If I didn't have the + sign in the formula, wouldn't I get the same result?


Don Guillett

What is purpose of + sign in formula "=+Q290*10"
 
It's a "throwback" to Lotus 123 or sometimes used as a shortcut on the
numeric keypad. Ignore or delete.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sasser" wrote in message
...
If I didn't have the + sign in the formula, wouldn't I get the same
result?



David Biddulph[_2_]

What is purpose of + sign in formula "=+Q290*10"
 
Yes.
The + is usually a relic of someone who previously used Lotus spreadsheets,
which used + where Excel uses =.
--
David Biddulph

"Sasser" wrote in message
...
If I didn't have the + sign in the formula, wouldn't I get the same
result?





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

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