Range in a row to return a value

[vazdajic]

Hello there.

I have 3 columns (A, B, C) based on which column D will have a result filled in (RETURNED VALUE):

Columns look like this:
A B C D (returned value)
OK OK OK OK
OK NO OK NO
OK OK OK
NO NO

OK OK NO NO

Cells in columns A, B and C are text values. Only possible ones are "OK" and "NO" where "NO" beats "OK". Cells may be empty, in such a case, returned value in column D is also empty.

How this can be done in a formula?

Thanks

 

[vazdajic]

Sorry everyone.. My Columns here in original thread look confusing as this forum site deleted my SPACES and I cannot upload a local picture of what I want (only web link is allowed).

A______B______C______D
OK____OK_____OK_____OK
OK____NO_____OK_____NO
_______________________
OK____OK____________OK
NO__________________NO

 

[Fluff]

Hi & welcome to the board
How about
=IF(COUNTA(A2:C2)=0,"",IF(COUNTIF(A2:C2,"no")>0,"NO","OK"))

 

[vazdajic]

Hi there.. Thanks for the Welcome.

I am unable to make this work.. Can you check the syntax of what you have suggested?

Thanks

Hi & welcome to the board
How about
=IF(COUNTA(A2:C2)=0,"",IF(COUNTIF(A2:C2,"no")>0,"NO","OK"))

 

[Fluff]

That formula needs to go in D2 & drag down, if you want to start in row 1 change all the 2 into 1

 

[vazdajic]

Hi.. I have tried. I have tried this with multiple IF clauses (IF+&IF...) but no success.. Hm...

That formula needs to go in D2 & drag down, if you want to start in row 1 change all the 2 into 1

 

[Fluff]

With the layout you've shown in post#2

Excel 2013 32 bit
	A	B	C	D
1	Header 1	Header 2	Header 3	Header 4
2	ok	ok	ok	OK
3	ok	no	ok	NO
4
5	ok	ok		OK
6	no			NO
7		no	ok	NO
8
9	ok	ok	no	NO
Sheet2

Cell Formulas
Range	Formula
D2	=IF(COUNTA(A2:C2)=0,"",IF(COUNTIF(A2:C2,"no")>0,"NO","OK"))

 

[vazdajic]

Ah.. I'm gonna go crzy.. maybe it's my Excel giving me issues (Office 2010 x86, Win7 64)

With the layout you've shown in post#2
Excel 2013 32 bit

	A	B	C	D
1	Header 1	Header 2	Header 3	Header 4
2	ok	ok	ok	OK
3	ok	no	ok	NO
4
5	ok	ok		OK
6	no			NO
7		no	ok	NO
8
9	ok	ok	no	NO

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula D2 =IF([COLOR=rgb(255]COUNTA(A2:C2)=0,"",IF(COUNTIF([COLOR=0)]A2:C2,"no"[/COLOR])>0,"NO","OK")[/COLOR]) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[Fluff]

What results are you getting?