IF statement - Check is the values are equal to the given numbers

**geliedee** · 07-04-2016, 06:41 AM

Hi All,

I have been stucked for days for this scenario in excel..

i have a data set and certain conditions

If cell a1 = 4 and cell b1 = 7 then Failed- no issues i have the formula..

The problem is here:

If a1 =4 and B1 <> 7 then passed..
If a1<>4 and B1 =7, and it should be passed too..

I am confused on how to this.. Hope someone can help me.

**Special-K** · 07-04-2016, 06:53 AM

Try

=IF(OR(AND(A1=4,B1=7),AND(A1<>4,B1=7)),"Passed","Failed")

This assumes the only way for the result to be "Passed" are the two conditions you specified above

IF statement - Check is the values are equal to the given numbers

LinkBack

Thread Tools

Rate This Thread

Display

IF statement - Check is the values are equal to the given numbers

Re: IF statement - Check is the values are equal to the given numbers

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to check values on two cells should be equal

[SOLVED] Ignore If Blank & check multiple cells for equal values

IF Statement to check ALL columns for certain numbers

[SOLVED] If statement won't recognize two values as equal

IF statement to check against list of values

[SOLVED] How do I check for values in a list in an if statement?

[SOLVED] check if 2 cells are equal but only if they contain numbers not i.

Bookmarks

Bookmarks

Posting Permissions