View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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