| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Threaded Mode
