Not really sure, but perhaps

=IF(LEFT(A3;2)="No";"No";IF(OR(B3=0;C3=1);"check"; IF(D3=4;"No";"")))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jam" wrote in message
oups.com...
Hi All people in this group
You always give permanent help, thanks
I want to do this
A B C D E
No 2 2 4
IF(LEFT(a1;2)="No";"No";IF(c2=1;"chek";IF(d2=4;"No "if
(b2=0;"check";"")))
No 0 1 1
IF(LEFT(a1;2)="No";"No";IF(c2=1;"chek";IF(d2=4;"No "if
(b2=0;"check";"")))
I tried or and and still takes only 1
Thank you for help
Other question, can I protect and hide several sheets in a workbook?
Regards
Jam