Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|