Remove NA error

Posted on 2011-03-14
Last Modified: 2012-06-21

I have the below formula which returns some NA errors, can i add to it so if its an NA error it returns blank for that cell


Question by:Seamus2626
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

akajohn earned 167 total points
ID: 35129020

Should do it. Please post results here.
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 167 total points
ID: 35129060
Perhaps you could use INDIRECT to get the sheet name for a shorter formula....


regards, barry

Assisted Solution

by:Russell Lucas
Russell Lucas earned 166 total points
ID: 35129063
You can wrap the whole thing in a IFERROR statment:-


If the formula returns any errors it will give you a blank cell.
LVL 50

Expert Comment

by:barry houdini
ID: 35129077
IFERROR is available in Excel 2007 and later so if you have that version you can apply Funinig Stroll's suggestion to mine to get



Author Closing Comment

ID: 35129302
Cheers guys!

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question