LinkBack URL
About LinkBacks
Hi All
I am trying to use the logical if formula to calclate points based on actual results of football matches against predicted scores but I am in a bit of a knot. Can anyone please help??
Hi All
I am trying to use the logical if formula to calclate points based on actual results of football matches against predicted scores but I am in a bit of a knot. Can anyone please help??
Try this
=IF(AND(C2=B2,F2=E2),3,IF(OR(AND(B2>E2,C2>F2),AND(E2>B2,F2>C2)),1,0))
Team wins or draws 1 pt
Pls give examples of predictions for when "Team wins" (whatever that means, ie which team?) and draw
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Try this in G2:
=IF(OR(C2="",F2=""),"",IF(AND(B2=C2,E2=F2),3,IF(OR(AND(B2>E2,C2>F2),AND(B2<E2,C2<F2),AND(B2=E2,C2=F2)),1,0)))
Hope this helps.
Pete
This formula didn't quite do the trick Special-K but the response from Pete is perfect. Thanks for your help, it was much appreciated
Catalpa
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks