# Thread: IF NO FOR ALL THEN.... (2000 sr-1)

1. ## IF NO FOR ALL THEN.... (2000 sr-1)

With macro ...
Assuming for each line (range L:AC) is present the first 2 character = NO insert in AD "OK" else "KO"...

on this case in line 15 all value init with NO insert in AD "OK"...
in line 13 "KO"...

2. ## Re: IF NO FOR ALL THEN.... (2000 sr-1)

Hi there!

I just want to make clear that I get this right. If any cell in Column AD is not no, you want the offset value in AD to be "KO"? Else it is to be "OK"?

Darryl.

3. ## Re: IF NO FOR ALL THEN.... (2000 sr-1)

acccccccccccc..... my english!!!!
No...
In effect scanning all cells in each line (rangeL:AC) and if in all cells of this line have first 2 carachter insert OK else KO

explain:

in cell L15, M15, N15...AC15 all cells have the first 2 character of value have NO, in this case the cell AD15 fil with OK...

in cell L13, M13, N13...AC13 all cells have the first 2 character of value have NO, but the cell AB13 the first 2 character of value have VE..in this case the cell AD13 fil with KO...

in other words,

if all cells (in range) have NO....... insert OK
if all cells (in range) have only one value different to NO insert KO
clear...
sorry me..

4. ## Re: IF NO FOR ALL THEN.... (2000 sr-1)

Don't worry about the English....It's my first language and still I can't talk it!

Give me a few minutes...let me see if I can figure it out.

Darryl.

5. ## Re: IF NO FOR ALL THEN.... (2000 sr-1)

:-) same for my Italian...
Tks for patience...

6. ## Re: IF NO FOR ALL THEN.... (2000 sr-1)

In cell AD2, enter the following array formula:

=IF(SUM(1*(LEFT(L2:AC2,2)="NO"))=COUNTA(L2:AC2),"O K","KO")

You must confirm the formula with Ctrl+Shift+Enter instead of Enter. Fill down as far as needed. See attached workbook.

7. ## Re: IF NO FOR ALL THEN.... (2000 sr-1)

I didn't have that in me

Hans is da best.

8. ## Re: IF NO FOR ALL THEN.... (2000 sr-1)

wow!!!
Tks as usual Hans, but with a macro?

9. ## Re: IF NO FOR ALL THEN.... (2000 sr-1)

Why?

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•