Thread: FIFA World Cup 2006 Office Pool
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default FIFA World Cup 2006 Office Pool

Hi Stewart,

try this formula in H2 copied across and down as necessary

=IF(C2<"",IF(C2=$G2,IF(C2="draw",5,3),IF($G2&"j"= C2,IF(C2="drawj",10,6),IF(RIGHT(C2)="j",-1,0))),"")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=535181

Reply With QuoteReply With Quote