OR Fucntion comes back as TRUE but as FALSE outside the function

I have a problem with one where Excel is coming up with a TRUE result within a function, but outside of the function, it comes up as a FALSE. Can anyone help?

First I have the OR function where one of the results is TRUE and I am receiving TRUE, see image below
2019-01-20_16-10-41.png

But outside of the OR function the IF function identifies the OR function as FALSE, see image below
2019-01-20_16-11-42.png

I have attached the Excel example file as well for anyone who wants to give it a go.

Any time you use OR, it will return TRUE or FALSE. So in your formula...
=IF(C47=(OR(C47="1 & OVER 1.5",C47="1 & OVER 2.5",C47="1 & OVER 3.5",C47="1 & OVER 4.5")),(IF(OR(G47="WIN",G47="V"),"W","L")),"-")
the BOLDED part will always only return True or False.
So you are saying if C47 (1 & over 2.5) = True (or False)...as you can see, it will never = C47.

If you will always only be testing for "1 & over some-value", you could also use...
=IF(C47="1 & OVER*",IF(OR(G47="WIN",G47="V"),"W","L"),"-")

Additional to Ford.
= C47 = OR(…)
= "1 & OVER 2.5" = TRUE , This is text "1 &…" compare with Boolean will get False
= FALSE

I change your formula to below but not sure about the result.
Please note the $ that help to copy the formula across and down.
https://support.office.com/en-us/art...e-5f0d8d0baca9

I make some change in K2:AF2

K6 drag to X6
=IF($C6="","",IF($C6=K$2,(IF(OR($G6="WIN",$G6="V"),"W","L")),"-"))

Y6 drag to AF6
=IF($C6="","",IF(ISNUMBER(SEARCH(Y$2,$C6)),(IF(OR($G6="WIN",$G6="V"),"W","L")),"-"))

Copy K6:AF6 Down