IF f1>G1;Win;loss

[Draco]

Hi, maybe it has been asked before, in that case sorry. I tried to find
it but I don't know the English term for what I am looking for.

I'm making a sheet in which I put results of matches. I want Excel to
put in a different cell (where I want to put the formula) if the result
is a "Draw", a "win" or a "loss"

So I made this one =IF(F4=G4;"DRAW";IF(F4>G4;"WIN";"LOSS"))

The funtion works, but not as it should! Can anybody help me with
this?

So if cell f4 = g4 it should print DRAW
if cell f4 > g4 it should print WIN
if cell f4 < g4 it should print LOSS

I get LOSSES and DRAW's but no WINS!

 

[Bob Phillips]

Looks fine, what do you have in F4 and G4?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Draco]

I have numbers in there. Example F4 = 4 and G4 = 2

This would result in the function I put in Cell E4 to be WIN, but I get
LOSS!

And I always get DRAW when cell F4 is filled with 0!