View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Evalution of a cell-entry

Do you really need the + in S90? If it just contained M20, then in T90
you could have something like this:

=IF(COLUMN(INDIRECT(S90))<COLUMN(S90),"less than","greater or equal")

Hope this helps.

Pete

On Dec 4, 1:55*pm, "Gilbert DE CEULAER"
wrote:
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)).