View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jboss73
 
Posts: n/a
Default Simple Function question?

This is a simple mistake but for some reason I can not get around it...any
help would be great.

What I am trying to accomplish is to have one cell (in this case T11)
display the winner of a game from cells R10 and R12. I am using "IF" , <
and = to display the winner or a tie. The problem I am running into is if
they two cells have not played yet, it will show in cell T11 the first cell
(R10) as the winner. Is there a formula to add to this so it will not show a
winner in T11 until a number is in place? Here is my formula:
=(IF(S10S12,R10,R12)+IF(S10=S12,0))