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

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?

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

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

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

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