Try in M1:
=IF(K1="WINNER","WINNER",IF(L1="BOOBY","BOOBY",""))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Silvabod" <[email protected]> wrote in message
news:[email protected]...
> Cells in Col K contain EITHER text OR null, as the result of a function
> test.
> Cells in Col L contain EITHER text OR null, as the result of a different
> function (which is triggered only when the function in Col K cells yields
a
> text value). Since 2nd function is dependant on the first, both cannot
exist
> in the same cell (circular reference).
>
> Need - Cells in Col M to contain EITHER the textvalue in K (if positive)
OR
> the textvalue in L (if positive) else null
>
> I can't get my head round the correct function nesting layout - help?
>
> =IF(OR(K1,"WINNER","WINNER",""(L1, "BOOBY", "BOOBY")"") don't work! (nor
can
> I find a google example).
>
> In practical terms - Cells K1:K60 function tests the adjacent row of 6
> cells, if ALL 6 are positive, displays WINNER.
> If ANY cell in Col K yields WINNER, Cells L1:L60 function tests same row
of
> 6 cells, if ALL 6 are negative, displays "BOOBY". If both tests fail,
cells
> K and L are left blank. These functions work.
>
> Problem is that Winner and Booby are displayed in adjacent columns - what
I
> want is just a ONE column print display, SO - hide cols K & L, copy text
in
> K or L into M (and there cannot be text in BOTH K and L in same row, it
> can't be both a winner and booby!).
>
>
>
>
Bookmarks