Hi Raz, Thank you for getting back to me so quickly. I tried your formula,
but it didnt work and EXCEL didnt offer me an alternative to it. I even did
the contrl+shift+enter and still didnt work out. Is there supposed to be 4
parenthesis at the end?

Thanks,
Wendy

"Raz" wrote:

try this

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



"Wendy" wrote:

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