Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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(F4G4;"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! ![]() -- Draco ------------------------------------------------------------------------ Draco's Profile: http://www.excelforum.com/member.php...o&userid=32426 View this thread: http://www.excelforum.com/showthread...hreadid=521928 |