View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Sports Comp Ladder tabulating help needed

In Situation 1, you can use this formula in your third cell:

=IF(Cell2-Cell1=7,1,0)

In Situation 2 (assume tries scored is in Cell4 to avoid confusion),
put this formula in Cell5:

=IF(Cell4=4,1,0)

The bonus points for this team are thus:

=Cell3 + Cell5

Hope this helps.

Pete