I have a spread sheet in which cells L2:L6 must be worked in order, and in
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"),"Y ES","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