In my attached screenshot, I have a formula in cell T17 with an iferror pretext to prevent errors from showing up if no value is associated with that name, however, instead of returning -- like I'm telling it to it's returning a 0 value instead which I don't want. Any idea why and how I can get it to show as -- ?
Thanks!
It's hard to tell without the workbook to actually look through, but are you sure the data in the Player Databse from which the formula is pulling is not zero? Also, you could use Excel's formula evaluator to determine whether it is actually the IFERROR() part of your formula that is returning a zero, and not a different part:
Hit ALT+T+U+F to open the Formula Evaluator.
Spread the love, add to the Rep
"None of us are as smart as all of us."
Seems like it would be the INDEX part of your formula returning the 0 error instead of the whole INDEX/MATCH.
Yes in the player database it's blank, there isn't a value or formula or anything, just an empty cell.Originally Posted by mcmahobt
What would I need to adjust to make it read -- or even a blank, anything but an error or 0?
I think your formula is resulting in 0 without an error, so maybe:-
=IFERROR(IF(yourformulahere=0,"--",yourformulahere),"--")
To test that it is not resulting in error, remove the iferror part of you formula and the result should still be 0
Last edited by Beamernsw; 02-10-2015 at 09:46 AM.
Ya that's what I have already.
What is the formula returning without the IFERROR() portion? Highlight your INDEX/MATCH formula and hit F9. What does that return?
The same, a 0.
iferror(if(your formula=0,"--",your formula),"--")
Separate the ifferror bit from the index match bit and use the above structure. You'll get an -- for zeros and for errors.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Make sure that there is truly no data within your INDEXed portion of your formula then. If there was truly no match, the result of the formula should be a #N/A. Sometimes a space or an ="" can be misconstrued as an empty cell. A good way to test this is to use the ISBLNAK() or ISEMPTY() functions.
I keep getting too many errors for this function when trying this, any chance you could type it out for me so I can paste it in how it should look? Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks