IF statement

I am sure it is very easy but today I have spent too long on this and cannot work it out.

Appreciate someone helping me out.

I have Two Columns 'Q and R':

In 'Q and R' I can have Valid or Invalid.

I need a formula that says:

IF Q is the same as R answer is Desk

IF Q=Valid and R=Invalid answer is Okay

IF Q=Inalid and R=Valid answer is Recall


Please make my day.

Thanks
JagwarmanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

frankhelkCommented:
Including some logical simplifications ( & presumed to be in row 1), I would use :

=IF(Q1=R1;"Desk";IF(Q1="Valid";"Okay";"Recall"))

(Simplification: Second IF only active if Q1<>R1, therefore if Q1=Valid", R1 must be "Invalid". In second IF, no third IF is needed, because if Q1<>"Valid", it must be "Invalid" which implies that R1 must be "Valid" due to Q1<>R1 from first IF)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Just remember that depending on your regional settings, you may need to use a comma instead of the semicolon in the formula.
0
JagwarmanAuthor Commented:
I changed the ; to , and it works perfect. thanks
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

frankhelkCommented:
Just remember that depending on your regional settings, you may need to use a comma instead of the semicolon in the formula.

Well - there's even more than that ... many keywords are language dependent. For example, the "IF" in english versions is "WENN" in german Excel versions. I was not aware of the comma vs. semicolon issue.

This is possible because Excel stores formulas with internal tokens instead of the keywords (like early BASIC interpretes did for size reasons) and delimiters. With that, a sheet created with a french version works well in german versions and has the correct keywords and tokens for the german language when it shows formulas.

This behaviour is nontheless annoying when I have to explain sth to someone in another country ...
0
JagwarmanAuthor Commented:
well I appreciate you help Frank
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Frank, the good news is that an attached Excel file will cross the language and regional settings boundary easily. If I write an English IF(something,something,something) statement and attach the file, a user with German Excel can open it and will see WENN(something;something;something).

Therefore, when there is a chance of regional or language settings complicating the issue, attach a file.

cheers, teylyn
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.