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
|