IF statement with multi criteria returns "#N/A"

**ms.excelnewbie** · 12-06-2012, 11:36 AM

I need to create an IF statement to identify a specific scenario that occurs within a large amount of data. I have the criteria that needs to be met in cells B1-B4, but the fields that I'm matching them to are in different rows and columns (in this example it's row 11 columns F&D, and column AA rows 9&4). This is the formula that I'm using but it keeps returning "#N/A" where it should be returning a "YES"
=IF(AND(F11=B1,AA9=B2,D11=B3,AA4=B4),"YES","NO")
Please help!!
Thank you

**Legend Rubber** · 12-06-2012, 11:38 AM

can you attach a sample workbook?
Also, your code needs to be in code tags.

**FDibbins** · 12-06-2012, 11:40 AM

check te cells that are being tested, and make sure none of them are returning an error message

if that still doesnt help, i would suggest you upload a sample workbook for me to look at

**Legend Rubber** · 12-06-2012, 11:42 AM

This is workign for me...

**FDibbins** · 12-06-2012, 11:42 AM

@ Legend Rubber, you only really need to use code tags if you are pasting VBA code here. some people use code tags or quote tags for formulas if they are very long (span multiple lines), but otherwisew, for a simple formula like the 1 above, tags are not really necessary

**Sindhus** · 12-06-2012, 11:43 AM

Any of the cells used in the cell returning any error? Do they contain valid data?

**Legend Rubber** · 12-06-2012, 11:48 AM

@FDibbins, thanks for the adjustment...
i didnt know that...
Sorry ms-excelnewbie

**ms.excelnewbie** · 12-06-2012, 11:49 AM

Here's a sample of the file with the formula in it.

**Sindhus** · 12-06-2012, 11:51 AM

B2 cell is showing error!

**ms.excelnewbie** · 12-06-2012, 11:56 AM

No, the "#N/A" is actually the proper returned result. That's what it shows when there's no exceptions, and that's the value that I want as part of the criteria

**Sindhus** · 12-06-2012, 11:58 AM

But i think excel can recognize it as error only. Can't it be represented in some other way?

**FDibbins** · 12-06-2012, 11:58 AM

Originally Posted by FDibbins

check te cells that are being tested, and make sure none of them are returning an error message

perhaps you missed this post?

**ms.excelnewbie** · 12-06-2012, 12:06 PM

Thank you!! I changed the "#N/A" to simply "N/A" and it worked!!

Thanks again for your help!!

**FDibbins** · 12-06-2012, 12:10 PM

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

**martindwilson** · 12-06-2012, 12:38 PM

fwi worth you can use formuls tags

Formula:

Please Login or Register  to view this content.

IF statement with multi criteria returns "#N/A"

LinkBack

Thread Tools

Rate This Thread

Display

IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Re: IF statement with multi criteria returns "#N/A"

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions