Excel Formula
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.
|