2 qurstions

[jam]

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

[Bob Phillips]

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" <jam2006@mail2world.com> wrote in message
news:1151404383.619210.115380@i40g2000cwc.googlegroups.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
>

[jam]

Hi Bob
What I want to is
I have in column A three categories, no, ok, pass
in column B is a number
in column c a number
I want to check if column A is No, and column b is 0 and column c is 1
or 4, if all these conditions are ok, then I want to check the
possibility of help, otherwise it is no
forhet about column D since it is the sum of b and c
the problem is the formula takes the condition of A and b and not in c,
in this the formulae will be in column D
Thanks for your swift and valuable reply
Regards
Jam

Bob Phillips wrote:
> 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" <jam2006@mail2world.com> wrote in message
> news:1151404383.619210.115380@i40g2000cwc.googlegroups.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
> >

[Bob Phillips]

So is this it

=IF(AND(A2="No",B2=0,OR(C2=1,C2=4)),"check","No")

--
HTH

Bob Phillips

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

"jam" <jam2006@mail2world.com> wrote in message
news:1151407956.652344.25550@75g2000cwc.googlegroups.com...
> Hi Bob
> What I want to is
> I have in column A three categories, no, ok, pass
> in column B is a number
> in column c a number
> I want to check if column A is No, and column b is 0 and column c is 1
> or 4, if all these conditions are ok, then I want to check the
> possibility of help, otherwise it is no
> forhet about column D since it is the sum of b and c
> the problem is the formula takes the condition of A and b and not in c,
> in this the formulae will be in column D
> Thanks for your swift and valuable reply
> Regards
> Jam
>
> Bob Phillips wrote:
> > 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" <jam2006@mail2world.com> wrote in message
> > news:1151404383.619210.115380@i40g2000cwc.googlegroups.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
> > >
>