2 qurstions
 

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

2 qurstions
 

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

2 qurstions
 

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" 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

2 qurstions
 

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" wrote in message
ps.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" 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