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

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?

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 .