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

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 .