Multiple Ifs
 

I am making a sheet for a football team and want a box to show W i
c10d10, D if C10=d10 and L if C10d10. Is this possible using excel

--
phil200
-----------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...fo&userid=3509
View this thread: http://www.excelforum.com/showthread.php?threadid=56376

Multiple Ifs
 

=IF(C10D10, "W", IF(D10C10, "L", IF(D10=C10, "D")))

You put C10D10 twice.. so you might have to readjust the formul

--
Bearacad

-----------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...fo&userid=3501
View this thread: http://www.excelforum.com/showthread.php?threadid=56376