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.

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.

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.