Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to "sign" macro with "digital certificate"? | New Users to Excel | |||
Purpose of "--" Operator | Excel Discussion (Misc queries) | |||
Purpose of "--" Operator | Excel Discussion (Misc queries) | |||
an extra "+" sign in formula | Excel Discussion (Misc queries) | |||
How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel |