Excel Formula
EMoe wrote:
I don't think I explained myself well at first.
That is an understatement! ;-)
What I want to write is; if cell A1 is less than 38, say empty. If A1
is greater than 38, but less than 39, say one quarter. If A1 is greater
than 39, but less than 40, say half. If A1 is greater than 40, but less
than 41, say three quarters. If A1 is greater than 41, say full.
I will assume that you mean "greater than or equal to" whenever you say
"greater than".
=if(A1<38, "empty", if(A1<39, "quarter", if(A1<40, "half", if(A1<41,
"three quarters", "full"))))
A more concise way to formulate the same thing is:
=if( A1<38, "empty", lookup(A1-38, {0,1,2,3}, {"quarter","half","three
quarters","full"}) )
|