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)).
|