W

#### Wendy

cell L7 I want to put a Yes or No if those cells were worked in order. a Y

or an N means I have completed the work for those cells. For ex, if its goes

in this order -

L2 = y, and L3= y, and L4,5,6 are all N, then I should have a YES in L9

because I started with L2 and worked my way down.If I did this,

L2= y, L3= y, L4 = n, L5 =y, and L6 = n, than it shows that I worked my

cells out of order and they should have a big fat NO in box L9. Here is the

IF/OR statement I wrote, but its not working.

=IF((OR(L2="Y",L3="N",L4="N",L5="N",L6="N"),"YES","NO"),IF(OR(L2="Y",L3="Y",L4="N",L5="N",L6="N"),"YES","NO"),IF(OR(L2="Y",L3="Y",L4="Y",L5="N",L6="N"),"YES","NO"),IF(OR(L2="Y",L3="Y",L4="Y",L5="Y",L6="N"),"YES","NO"))

I'm very new with excel, and not sure about where to put comma's, etc. or if

this would even be an IF statement function as opposed to a LOOKUP. Any help

would be very much appreciated. Thanks!

Wendy