| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help Needed . .
Again, thanks Steve.
"Steve Dunn" wrote: =if((Fixtures!C7="")+(Fixtures!D7=""),"",((Fixture s!C7Fixtures!D7)*(B4C4)+(Fixtures!C7<Fixtures!D7 )*(B4<C4)+(Fixtures!C7=Fixtures!D7)*(B4=C4))+2*(B4 =Fixtures!C7)*(C4=Fixtures!D7)) "J.Scargill" wrote in message ... Steve, Only minor problem I have now is that all predictions of a draw are returning a 1 or a 3 because the cells they are pulling from are blank! Can you suggest anything to cure this? It will cause a problem when I come to populate the league table as it will count the 1s and 3s on games that havent been played and invalidate the individuals score. "Steve Dunn" wrote: You're welcome, glad to help. "J.Scargill" wrote in message ... Steve, that is fantastic! Works like a dream. Thankyou very much. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
| Formula needed | New Users to Excel | |||
| Formula help needed | Excel Worksheet Functions | |||
| If Then Formula Help Needed | Excel Worksheet Functions | |||
| Formula help needed ! | Excel Discussion (Misc queries) | |||
![J.Scargill[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
