Excel 2007 : Nested IF, AND IF, ISNA IF.. Arghhh

**myvlturbo** · 06-25-2010, 03:42 AM

Just beginner here some guidance would be appreciated. please PM me if you have the time for me to explain..

Cheers

**Marcol** · 06-25-2010, 05:31 AM

Hi welcome to the forum.

The first thing to explain might be.

Why post a word document with a screenshot of your workbook?

Post the workbook!

Then consider the forum rules for thread titles before the moderators get you .....

....No?

**myvlturbo** · 06-25-2010, 09:15 PM

Originally Posted by Marcol

Hi welcome to the forum.

The first thing to explain might be.

Why post a word document with a screenshot of your workbook?

Post the workbook!

Then consider the forum rules for thread titles before the moderators get you .....

....No?

Sorry, the excel file was too big ...So I did the screenshot of the spreadsheet with the formula i currently have and the instructions i have been given, I need to put a part number in the first column B6 (this is from a Vlookup in another tab)..However if there is not a matching part i get #NA return .. So instead i need to return (invalid part ) so was wondering which formula to use..nested ifs, and / ifs, isna and if, isna /if..

Cheers Des

.