asked on

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

ASKER CERTIFIED SOLUTION

Frank Helk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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

Jagwarman

ASKER

I changed the ; to , and it works perfect. thanks

Frank Helk

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 ...

Jagwarman

ASKER

well I appreciate you help Frank

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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