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

O

Oskar

*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*
 
D

daddylonglegs

Try

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

Cutter

Try:

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

Difficult1

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

Sloth

=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").
 
Top