# More Excel teasers.

Legolas 22:03 06 Dec 04
Locked

I with the help of VoG successfully solved this Excel problem click here

I now want to solve another problem of a similar nature.

I have set up the Excel s/sheet so that if I enter an "N" in column G2 it will put a "Y" in column "P2" using the formula VoG gave me.

That is fine and is what I want because if the value in G2 is "N" the value in P2 must be a "Y"

BUT the final value in P2 is also affected by the value in H2 so if the value in H2 is a "Y" the final value in P2 must be a "N" in other words if the value in G2 and H2 is an "N" then the final value in P2 is a "Y" but if either G2 or H2 have a "Y" then the final value of P2 must be "N".

Confusing isn't it.

I have successfully got P2 to change to the opposite of what I enter in G2 but I want P2 also to change in respect to what I enter in H2

Here is the formula I am using =IF(G2="N","Y","N")

this successfully changes the value in P2 to the opposite of G2 but how do I get it to change the value in P2 in respect to what is entered in H2.

WHEW

Legolas 22:08 06 Dec 04

Whoever can understand and work this one out will be sent the price of a few drinks - Honest

pc moron 22:20 06 Dec 04

If I understand correctly, this should do what you want:

=IF(AND(G2="N",H2="N"),"Y",IF(OR(G2="Y",H2="Y"),"N",""))

Legolas 22:30 06 Dec 04

Many thanks this will save me much time and labour

Legolas 22:33 06 Dec 04

See you had to help me I can't even spell ;-)

This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced