Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel ISERROR question

Posted on 2011-02-28
5
Medium Priority
?
348 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
  • 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 2000 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

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 …
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

916 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