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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks