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 |