Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Hi, Would you please help me to understand the formula below? What is the " +'All information Data' ? I know that the "All information Data" is a name of the sheet, but I am not sure about the + sign before it. Thanks Chi =+'All Information Data'!D60 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
The "+" is not really required.
-- Gary''s Student - gsnu200909 "Chi" wrote: Hi, Would you please help me to understand the formula below? What is the " +'All information Data' ? I know that the "All information Data" is a name of the sheet, but I am not sure about the + sign before it. Thanks Chi =+'All Information Data'!D60 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Thank you very much!
"Gary''s Student" wrote: The "+" is not really required. -- Gary''s Student - gsnu200909 "Chi" wrote: Hi, Would you please help me to understand the formula below? What is the " +'All information Data' ? I know that the "All information Data" is a name of the sheet, but I am not sure about the + sign before it. Thanks Chi =+'All Information Data'!D60 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Gary gave you the correct answer, here is the answer to "why did someone put
it there?" Many old times (like me) started or spreadsheet life with Lotus (or VisiCalc) and that required a formula to begin with + Some have not broken the habit (old dogs/ new tricks?) best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "Chi" wrote in message ... Hi, Would you please help me to understand the formula below? What is the " +'All information Data' ? I know that the "All information Data" is a name of the sheet, but I am not sure about the + sign before it. Thanks Chi =+'All Information Data'!D60 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|