Solved

Excel ISERROR question

Posted on 2011-02-28
5
339 Views
Last Modified: 2012-05-11
Hi Experts:
I have this formula on cells in my spreadsheet:
=IF($A$1="ALL",Data!A4,IF(ISERROR(FIND($A$1,Data!D4)),"",Data!A4))

The spreadsheet contains a value in A1 which can vary.  The data as you can see comes from another spreadsheet.  If the A1 value does not match the Data spreadsheet D4 cell, I want a blank or null.  Now I am getting zeros when there is no match.

I hope this makes sense.

Thank you.
0
Comment
Question by:snix123
[X]
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
  • 2
  • 2
5 Comments
 
LVL 45

Expert Comment

by:patrickab
ID: 35000750
Try:

=IF($A$1<>Data!A4,"",IF(ISERROR(FIND($A$1,Data!D4)),"",Data!A4))
0
 

Author Comment

by:snix123
ID: 35006712
I still get a 'zero'.  Researching this further...thanks for your help, though.
0
 
LVL 1

Expert Comment

by:TonyWong
ID: 35241460
Hi there, not sure if this is resolved yet but you may want to check out your settings.

Depending on what version of Excel you have, go to File->Options->Advanced.
In the dialog box that pops up, go to 'Show zero in cells that have a zero value' and uncheck it.

Cheers,
Tony
0
 

Author Comment

by:snix123
ID: 35243747
Thank you for your input.  The problem was that the cells were never blank since they had a formula in them!  Have rescoped how things were happening and it seems o.k. now...can we close this one?
0
 
LVL 1

Accepted Solution

by:
TonyWong earned 500 total points
ID: 35260047
Still, if the formula in the cell is returning a '0' value (and it's supposed to be that as a result) then what I suggested should stop displaying the zeroes.

snix123, it's up to you if you want to close it as you're the OP :)
0

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

739 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