[Solved] stopping"FALSE" appearing

[jimbokea]

Hi - in the formula
=IF(F115>14;"won";IF(C115>14;"lost";IF(F115=14;IF(C115=14;"drawn"))))
How do I stop the word "False" appearing if the criteria is not met?
i.e - neither side has reached 14 or above to win or draw.
I tried adding ;"" at the end but 'false' still appears.
cheers Jim

[robleyd]

Code: Select all

=IF(F115>14;"won";IF(C115>14;"lost";IF(AND(F115=14;C115=14);"drawn")))

[jimbokea]

I got the same result with my formula - your formula still returns "False" for say 14 and 12 values for the C115 & F115. I don't want "false" to appear, just a blank. As I said, I usually add ;"" to return a blank if non of the criteria met but not working in this case for some reason.

[jimbokea]

Must have copied it wrong - added ;"" and it now works - cheers Jim

[Villeroy]

=F115-14
with 3 part number format

Code: Select all

"won";"lost";"drawn"

or including some highlighting:

Code: Select all

[BLUE]"won";[RED]"lost";"drawn"

Mind that the true cell value is simply the difference between F114 and 14

[jimbokea]

The two teams (A & B) play 28 games in all over the day with a game win worth 1 and a game draw worth 0.5
The first to 14.5 "won" and the other team "lost"- if both get 14 then "drawn".
Nothing is to appear in this cell until one of the above is met. i.e. you could have 5 for one team and 10 for another which is not a result yet.
There are 4 teams playing each other so there are other results of A v C, A v D, B v C, B v D & C v D
What I have now works fine. Thanks - Jim