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
|