LinkBack URL
About LinkBacks
I'm using:
=IFERROR(J10/J9, "")
to eliminate the error in cell. Occasionally my data also has an instance where there's no dividing by 0 but 0 is divided by a number. Can I have that also display as a blank instead of the quotient – 0?
Thank you
I'm using:
=IFERROR(J10/J9, "")
to eliminate the error in cell. Occasionally my data also has an instance where there's no dividing by 0 but 0 is divided by a number. Can I have that also display as a blank instead of the quotient – 0?
Thank you
Here's the most straightforward way:
Formula:
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Maybe this...
=IFERROR(1/(1/(J10/J9)),"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
it worked, thanksOriginally Posted by 6StringJazzer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks