View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gilbert DE CEULAER Gilbert DE CEULAER is offline
external usenet poster
 
Posts: 25
Default Evalution of a cell-entry

??? the result is "#REF!" ???

"Bob Phillips" wrote in message
...
=COLUMN(INDIRECT(S90))<COLUMN(S90)

--
__________________________________
HTH

Bob

"Gilbert DE CEULAER" wrote in message
...
Cell M20 contains "Whatever".
Cell S90 contains "+M20"
In order to verify things, in T90, I want to know the row, column, or
address of what is really in S90, I mean I want "M20", not the contents
("Whatever").
How can I do that ?
(Actually, in T90? I want to make a formula checking whether the
column-number mentioned in S90 ("M"=13) is less, equal or greater than
the column-number of S90 itself ("S"=19)).