=CHOOSE(1+(E10>0)+(E10>5)+(E10>8)+(E10>11),"zero","Less Than Half","Half
Time","Three Quarter Time","Full Time")

I added the "zero" because you didn't specify what happens at all other
times (0 and negative numbers will result in "zero").

"Oskar" wrote:

>
> *One final problem and I’ll leave you alone….
> Excel 2000
>
> If (E10) is greater than 11 “full time”, IF (E10) is greater than 8 but
> less than 12 “Three Quarter Time” IF (E10) is greater than 5 but less
> than 9 “Half Time” ” IF (E10) is greater than 0-5 “Less than Half
> Time”
>
> Thanks again in advance
>
> John*
>
>
> --
> Oskar
> ------------------------------------------------------------------------
> Oskar's Profile: http://www.excelforum.com/member.php...o&userid=32745
> View this thread: http://www.excelforum.com/showthread...hreadid=525830
>
>