Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help Formula 1

Status
Not open for further replies.

jatolo

MIS
Jul 17, 2006
40
US
I need please help with this "formula",
two options one winner.
Score C4 D4
3 0
Option A: C5 D5
2 2
Option B: C6 D6
3 3
Winner D7=1 Point
C5 D5 Match C4 D4 or C6 D6 match C4 D4
=If(C5=C4)and(D5=D4)or(C6=C4andD6=D4),1,0
Thanks for your help
 
syntax is as follows:

=if(or(and(condition1, condition2),and(condition3,condition4)),Result If True,Result If False)

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top