thanks
--
Gary''s Student - gsnu200768


"Don Guillett" wrote:

try this logic to get to the last one
=trim(a1)
=len(trim(a1))
=if(len(trim(a1))<1,1,2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary''s Student" wrote in message
...
Is it possible, without VBA, to test the €œemptiness€� of a cell? For
example,
a formula that will return 1 if a cell is unused (has nothing in it), 2 if
the cell has a formula returning a null string:

=IF(1=1,€�€�,€�€�)

3 if the cell has a single quote in it and 4 otherwise?

--
Gary''s Student - gsnu2007xx