Good point.

Care to comment on:

=LOOKUP(A1,{-9E+307,38,39,40,41;"Empty","One Quarter","Half","Three
Quarters","Full"})
?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
oups.com...
Ragdyer wrote:
For simplicity:
=LOOKUP(A1,{0,38,39,40,41;"Empty","One Quarter","Half","Three
Quarters","Full"})

That presumes a constraint on A1 that the OP did not state, namely that
A1 will not be less than zero. The OP said only that A1 can be less
than 38; that does not preclude negative values. If A1 were negative,
your formulation would return #N/A. I consider that unaccecptable.