![]() |
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?
|
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? |
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? |
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