+ Reply to Thread
Results 1 to 3 of 3

Hiding #DIV/0! Error

  1. #1
    Registered User
    Join Date
    04-20-2007
    Posts
    2

    Hiding #DIV/0! Error

    I have a column of formulas that is basically total cost of product/number of uses=cost per use. When none of the specific product is being used, I get a #DIV/0! error. I know what this is telling me, but I am looking for a way to hide it, just to make my spreadsheet look tidier to customers while we are in the process of manipulating numbers.

    Does any one know how to do this?

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    =if(iserror(your formula),"",your formula)

    where your formula is what is in the cell now, such as =a1/b1
    not a professional, just trying to assist.....

  3. #3
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    I use Conditional formatting with a custom function =ISERROR(a1) that will turn the font color white.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1