Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i do a compound if function?
I am doing a football predictor competition wher people predict the scores
for games. I need to be able to award 3 points to the correct score. and 1 point for the correct result from a predicted score to the actual score. Is there any way of doing this? Thank you in advance. If there is any more information needed then please ask and i will elaborate further. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i do a compound if function?
It's a little difficult to answer without more information.
But maybe these will give you a start: Nested IF statements. You can 'nest' up to 7 levels (Excel 2003) of IF statements like this: =IF(A1=1,"1st if true",IF(A1=2,"2nd if true","neither IF true")) IF with logical tests. You can also use logical tests like AND and OR as the test in an IF statement (and you can combine this with nested IFs also): =IF(AND(A1=1,B1=X1),"both matched","at least one did not match") Hope this helps get you started. "mikey" wrote: I am doing a football predictor competition wher people predict the scores for games. I need to be able to award 3 points to the correct score. and 1 point for the correct result from a predicted score to the actual score. Is there any way of doing this? Thank you in advance. If there is any more information needed then please ask and i will elaborate further. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i do a compound if function?
Everythign you ever wanted to know about the IF function (well, almost
everything): http://spreadsheets.about.com/od/exc..._funct_hub.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "JLatham" wrote: It's a little difficult to answer without more information. But maybe these will give you a start: Nested IF statements. You can 'nest' up to 7 levels (Excel 2003) of IF statements like this: =IF(A1=1,"1st if true",IF(A1=2,"2nd if true","neither IF true")) IF with logical tests. You can also use logical tests like AND and OR as the test in an IF statement (and you can combine this with nested IFs also): =IF(AND(A1=1,B1=X1),"both matched","at least one did not match") Hope this helps get you started. "mikey" wrote: I am doing a football predictor competition wher people predict the scores for games. I need to be able to award 3 points to the correct score. and 1 point for the correct result from a predicted score to the actual score. Is there any way of doing this? Thank you in advance. If there is any more information needed then please ask and i will elaborate further. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
future value function for compound interest | Excel Worksheet Functions | |||
I am having trouble with the IF function and a compound condition | Excel Worksheet Functions | |||
Loan Compound Interest Function | Excel Worksheet Functions | |||
How do I make a compound function? | Excel Worksheet Functions | |||
Compound Rate Function | Excel Worksheet Functions |