Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extremely funny formulae
i have a worksheet in xl2003 that accepts very crazy formulas and gives
equally weird answers. for example the following formulaes appear valid =connie =don =lucky these formulae give results that i dnt understand. any one ever come across such?? i can send u a screen grab or the full worksheet to your email |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
extremely funny formulae
They bring up #NAME? here, which is what you would expect.
The error code when excel can't understand the text string in a formula. What return are you getting? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
extremely funny formulae
Presumably names have been defined? Insert/ Name/ Define ...
-- David Biddulph "anthony" wrote in message ... i have a worksheet in xl2003 that accepts very crazy formulas and gives equally weird answers. for example the following formulaes appear valid =connie =don =lucky these formulae give results that i dnt understand. any one ever come across such?? i can send u a screen grab or the full worksheet to your email |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
extremely funny formulae
"connie", "don", "lucky" are probably named/defined ranges
(a range can also be a single cell, btw) To unravel the mystery and see all the named ranges: In a new sheet, select say, A1, then click Insert Name Paste Paste List (or just press F3 Paste List) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "anthony" wrote: i have a worksheet in xl2003 that accepts very crazy formulas and gives equally weird answers. for example the following formulaes appear valid =connie =don =lucky these formulae give results that i dnt understand. any one ever come across such?? i can send u a screen grab or the full worksheet to your email |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
extremely funny formulae
Try F3
This should bring up a list of defined names Or for more details Insert - Names - Define... There you'll find connie, don, lucky click on them and you'll see the value associated with them. Steve On Wed, 24 Jan 2007 08:02:01 -0000, anthony wrote: i have a worksheet in xl2003 that accepts very crazy formulas and gives equally weird answers. for example the following formulaes appear valid =connie =don =lucky these formulae give results that i dnt understand. any one ever come across such?? i can send u a screen grab or the full worksheet to your email |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
extremely funny formulae
This is an example of natural language formulas.
To enable it: Choose ToolsOptions, and on the Calculation tab, add a check mark to 'Accept labels in formulas' Then, you can refer to the column and row headings of table on the same worksheet. So, if you have a table with a heading "Connie", you can enter =Connie in a cell, and the result will be the first value of the Connie column. To sum that column, =SUM(Connie) There's more information in this Microsoft article: http://support.microsoft.com/kb/279412/en-us It's better to use named ranges, instead of depending on natural language formuals. anthony wrote: i have a worksheet in xl2003 that accepts very crazy formulas and gives equally weird answers. for example the following formulaes appear valid =connie =don =lucky these formulae give results that i dnt understand. any one ever come across such?? i can send u a screen grab or the full worksheet to your email -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: 'always choose same cell' symbol for use in formulae | Excel Discussion (Misc queries) | |||
Recalculation of formulae disabled | Excel Discussion (Misc queries) | |||
Change to formulae | Excel Worksheet Functions | |||
XL2002 Clipboard doesn't paste formulae | Excel Discussion (Misc queries) | |||
vlookup change column index position - without changing formulae | Excel Worksheet Functions |