Thread
:
Formula starts =+(cell reference)
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Formula starts =+(cell reference)
It's a carryover from 123. Usually it is harmless to leave it in. Also some
parenthesis are unnecessary
Examples:
=+a1, =a1
=+C:\Excel\[WB]Sheet1!A1,
=+L187+(Q213), =l187+q213
=+Sum(A1:A33) =sum(etc
--
Don Guillett
SalesAid Software
"chaunceycupoo" wrote in message
...
Can anyone provide a detailed explanation of what it means when a formula
is
input into a cell with the addition sign immediately after the =.
Examples: =+a1, =+C:\Excel\[WB]Sheet1!A1, =+L187+(Q213), =+Sum(A1:A33)
I inherited several spreadsheets that I am revising that use this
convention
and I can't seem to find any information on what it means other then a
note
in Excel for Dummies stating this means you want to make the value
"explicitly positve"
Does anyone have more information on this. Thanks in advance for any help.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett