Need some help again please.
G1 contains a list box, contained in the list box:
OFF 1 2 3 4 5 6 7

N6 will contain the if statements:
If G1=Off will return a statement in cell N6 of OFF
If G1=1 (1-6) will return a statement in cell N6 of WORK
If G1=7 will return a statement in cell N6 of REST 24 HOURS
The following formula does not work:
=if(and(g1="OFF","OFF"),if(g10,g1<7,"WORK"),if(g1 ="7","REST 24 HOURS"))
of course i have tried each number with own if statement but ran into that
proverbial 7 if statements.

Any advice, input would be valuable, thanks in advance.
Doug