Another Basic formula I should know (but Don't)

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

Try

=IF(E10="","",LOOKUP(E10,{0,5,9,12;"Less than Half","Half","Three Quarter","Full"})&" Time")

Try:

=IF(E10>11,"Full Time",IF(E10>8,"Three Quarter Time",IF(E10>5,"Half Time",IF(E10>0,"Less Than Half Time",""))))

Works Great

You can do it one of two ways... a nested if function... or ( I think the
easier way) a vlooup function.




"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
>
>

=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
>
>