Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula help
Hello, I am trying to work out a point scoring system and have the following formula =IF(OR(C9="",F9="",'Winning Scores'!C7="",'Winning Scores'!F7=""),0,IF(C9+F9='Winning Scores'!C7+'Winning Scores'!F7,"3","0")+IF(OR(AND(C9F9,'Winning Scores'!C7'Winning Scores'!F7),AND(AM!C9<AM!F9,'Winning Scores'!C7<'Winning Scores'!F7)),1,0)) Which is basically saying that if C7 and F7 = C9 and F9 in the 'winning scores spreadsheet, to give 3 points but it is returning 3 points if C7=F9, and I only want it to relate to C7 - do you know how I would do this? I also need to award 1 point if the highest score is chosen but not if the exact score, hence if the score was '3' '2' and the person chose these exact numbers 3 points would be awarded but it they chose '3' 1' only 1 point would be awarded as they chose the winning team any light you can shed would be greatly appreciated! thanks nx -- n1kk1 ------------------------------------------------------------------------ n1kk1's Profile: http://www.excelforum.com/member.php...o&userid=35173 View this thread: http://www.excelforum.com/showthread...hreadid=551005 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula help
Hi
Similar to an answer I gave earlier to another post: With your actual score in C2 and D2 and your predicted score in G2 and H2, try something like this: =IF(AND(C2=G2,D2=H2),3,IF(OR(AND(C2D2,G2H2),AND( C2<D2,G2<H2)),1,0)) This gives 3 points for an exact score match and 1 point for a result match. If it doesn't exactly deal with your needs, post back with some examples of what you'd like! Andy. "n1kk1" wrote in message ... Hello, I am trying to work out a point scoring system and have the following formula =IF(OR(C9="",F9="",'Winning Scores'!C7="",'Winning Scores'!F7=""),0,IF(C9+F9='Winning Scores'!C7+'Winning Scores'!F7,"3","0")+IF(OR(AND(C9F9,'Winning Scores'!C7'Winning Scores'!F7),AND(AM!C9<AM!F9,'Winning Scores'!C7<'Winning Scores'!F7)),1,0)) Which is basically saying that if C7 and F7 = C9 and F9 in the 'winning scores spreadsheet, to give 3 points but it is returning 3 points if C7=F9, and I only want it to relate to C7 - do you know how I would do this? I also need to award 1 point if the highest score is chosen but not if the exact score, hence if the score was '3' '2' and the person chose these exact numbers 3 points would be awarded but it they chose '3' 1' only 1 point would be awarded as they chose the winning team any light you can shed would be greatly appreciated! thanks nx -- n1kk1 ------------------------------------------------------------------------ n1kk1's Profile: http://www.excelforum.com/member.php...o&userid=35173 View this thread: http://www.excelforum.com/showthread...hreadid=551005 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |