IF E3 & E10 = TRUE set this cell to "Yes", else set to "No"

I'm PHP/JavaScript programmer, so please bare with me as I'm not all to fimilar with Excel's way of doing IF and ELSE, MATCHing and such.
I rarely use Excel by the way.



Ok, I have a little problem figuring out how to make a formula for this, but here goes.



Game 1 (cell A3), Game 2 (cell A4), Game 3 (cell A5), Game 4 (cell A6), Game 8 (cell A10), Game 9 (cell A11) & Game 10 (cell A12)
are ALL available by default

Game 5 (cell A7)
requires Game 1 (cell A3) & Game 8 (cell A10) to be played 20 times each in order to be unlocked
the formula is in B7 respectively

Game 6 (cell A8)
requires Game 2 (cell A4) & Game 9 (cell A11) to be played 20 of times each in order to be unlocked
the formula is in B8 respectively

Game 7 (cell A9)
requires Game 7 (cell A5) & Game 8 (cell A6) to be played 20 of times each in order to be unlocked
the formula is in B9 respectively

Game 11 (cell A13)
requires Game10 (cell A12) to be played 30 of times to be unlocked
the formula is in B13 respectively

Game 12 (cell A14)
requires Game 5 (cell A7), Game 6 (cell A8), Game 7 (cell A9), & Game 11 (cell A13) to be played 30 of times to be unlocked
the formula is in B14 respectively



Formulas are in E3 to E14 that calculate whether or not a specific game has met the requirement to unlock another.
example: Game 1 (cell A3) has been played 10 times, but needs to be played 20 times to unlock or take part in the unlocking of another game. Cell E3 would then calculate whether or not 10 is greater than or equal to 20 and set the cell to "Yes" for TRUE or "No" for FALSE.
In the given example, 10 is NOT greater than or equal to 20 which would generate FALSE or "No" for the custom value.



I've already figured out the formulas for E3 to E14.




My problem is figuring out the formulas for B7, B8, B9, B13 & 14

Example:
I need a formula to see if BOTH of the 2 cells in the E column equal to TRUE ("Yes").
If they do, set the cell in B the column to TRUE ("Yes").
If neither match OR they are both FALSE, set the cell in the B column to FALSE ("No")




I hope someone understands this, if not, look at the attached excel file (created in Excel 2003).

First, don't post in MIME/HTML. Post in plain text.

Second, don't attach files. Unlike PHP or other source code files or even
HTML files, which are either plain text or could be viewed as plain text,
Excel workbooks are potential virus carriers, so anyone in their right mind
won't open Excel workbooks posted by strangers.

"Timothy L" wrote...
....
Game 7 (cell A9) requires Game 7 (cell A5) . . .

Do you mean game 3 in cell A5?

. . . & Game 8 (cell A6) . . .

Do you mean game 4 in cell A6?

. . . to be played 20 of times each in order to be unlocked the
formula is in B9 respectively
....
I need a formula to see if BOTH of the 2 cells in the E column equal
to TRUE ("Yes"). If they do, set the cell in B the column to TRUE
("Yes"). If neither match OR they are both FALSE, set the cell in the B
column to FALSE ("No")

=IF(AND(OneCell="Yes",AnotherCell="Yes"),"Yes")

I thought I did post in plain text. I must have forgot to change that. Ah,
oh well.

I've changed my settings in Outlook Express to correct it. This should now
be in plain unicode text.


Anywho...

About the attachment. Yes, you are right.

So I have converted it to a CSV file (Comma delimited) and attached that.



"Harlan Grove" wrote in message
...
First, don't post in MIME/HTML. Post in plain text.

Second, don't attach files. Unlike PHP or other source code files or even
HTML files, which are either plain text or could be viewed as plain text,
Excel workbooks are potential virus carriers, so anyone in their right
mind
won't open Excel workbooks posted by strangers.

"Timothy L" wrote...
...
Game 7 (cell A9) requires Game 7 (cell A5) . . .

Do you mean game 3 in cell A5?

. . . & Game 8 (cell A6) . . .

Do you mean game 4 in cell A6?

. . . to be played 20 of times each in order to be unlocked the
formula is in B9 respectively
...
I need a formula to see if BOTH of the 2 cells in the E column equal
to TRUE ("Yes"). If they do, set the cell in B the column to TRUE
("Yes"). If neither match OR they are both FALSE, set the cell in the B
column to FALSE ("No")

=IF(AND(OneCell="Yes",AnotherCell="Yes"),"Yes")

Attachments of any kind are strongly discouraged in newsgroups. Many
systems (such as Google) and individual users filter out all posts that
contain attachments. Consequently use of an attachment rather than a
good description limits your exposure and thus reduces your chances of
getting a prompt answer.

I understand your question to be how to write an IF formula that tests
for multiple conditions.
=IF((condition1)*(condition2),trueResult,falseResu lt)
tests whether both conditions (AND) are met
=IF((condition1)+(condition2),trueResult,falseResu lt)
tests whether either condition (OR) is met.

You can extend as desired
=IF((condition1)*(condition2)*((condition3)+(condi tion4)),trueResult,falseResult)
tests requires both 1 and 2 plus either of 3 or 4 ...

Jerry

Timothy L wrote:

I thought I did post in plain text. I must have forgot to change that. Ah,
oh well.

I've changed my settings in Outlook Express to correct it. This should now
be in plain unicode text.


Anywho...

About the attachment. Yes, you are right.

So I have converted it to a CSV file (Comma delimited) and attached that.



"Harlan Grove" wrote in message
...

First, don't post in MIME/HTML. Post in plain text.

Second, don't attach files. Unlike PHP or other source code files or even
HTML files, which are either plain text or could be viewed as plain text,
Excel workbooks are potential virus carriers, so anyone in their right

mind

won't open Excel workbooks posted by strangers.

"Timothy L" wrote...
...

Game 7 (cell A9) requires Game 7 (cell A5) . . .

Do you mean game 3 in cell A5?


. . . & Game 8 (cell A6) . . .

Do you mean game 4 in cell A6?


. . . to be played 20 of times each in order to be unlocked the
formula is in B9 respectively

...

I need a formula to see if BOTH of the 2 cells in the E column equal
to TRUE ("Yes"). If they do, set the cell in B the column to TRUE
("Yes"). If neither match OR they are both FALSE, set the cell in the B
column to FALSE ("No")

=IF(AND(OneCell="Yes",AnotherCell="Yes"),"Yes" )

So basically, this is along the lines of what I'm looking for:
=IF((E3="Yes")*(E10="Yes"),"Yes","No")


If cells E3 AND E10 have the value of "Yes" in them, return TRUE ("Yes").
If cells E3 AND E10 have any other value in them, return FALSE ("No").
If cell E3 has a value of "No", but E10 has a value of "Yes", return FALSE
("No").
And vice-versa:
If cell E3 has a value of "Yes", but E10 has a value of "No", return FALSE
("No").



I thank you for your help.



"Jerry W. Lewis" wrote in message
...
Attachments of any kind are strongly discouraged in newsgroups. Many
systems (such as Google) and individual users filter out all posts that
contain attachments. Consequently use of an attachment rather than a
good description limits your exposure and thus reduces your chances of
getting a prompt answer.

I understand your question to be how to write an IF formula that tests
for multiple conditions.
=IF((condition1)*(condition2),trueResult,falseResu lt)
tests whether both conditions (AND) are met
=IF((condition1)+(condition2),trueResult,falseResu lt)
tests whether either condition (OR) is met.

You can extend as desired

=IF((condition1)*(condition2)*((condition3)+(condi tion4)),trueResult,falseRe
sult)
tests requires both 1 and 2 plus either of 3 or 4 ...

Jerry

You are welcome.

Jerry

Timothy L wrote:

So basically, this is along the lines of what I'm looking for:
=IF((E3="Yes")*(E10="Yes"),"Yes","No")


If cells E3 AND E10 have the value of "Yes" in them, return TRUE ("Yes").
If cells E3 AND E10 have any other value in them, return FALSE ("No").
If cell E3 has a value of "No", but E10 has a value of "Yes", return FALSE
("No").
And vice-versa:
If cell E3 has a value of "Yes", but E10 has a value of "No", return FALSE
("No").



I thank you for your help.