+ Reply to Thread
Results 1 to 4 of 4

Nested Function - Receiving #DIV/0! - Need Masking Error Help

  1. #1
    Registered User
    Join Date
    12-18-2012
    Location
    Miami, Florida
    MS-Off Ver
    Excel 2007
    Posts
    61

    Nested Function - Receiving #DIV/0! - Need Masking Error Help

    Good morning.

    I have run into another dilema. I am using the following formula =IF(IsNumber(A20), (A20-A21)/A20,"-") and attempting to avoid (masking) receiving the #DIV/0! or #VALUE! errors. I need assistance with a nested function that will avoid these errors and just put a "-" (hyphen) in its place. FYI A lot of times there will be 0 in A20 and A21, so I need to mask the formula result. I have attempted to modify the previous assistance but still receive one or the other errors.

    Thanks a bunch. Deanna

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Nested Function - Receiving #DIV/0! - Need Masking Error Help

    Maybe something like this...

    =IFERROR((A20-A21)/A20,"-")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    12-18-2012
    Location
    Miami, Florida
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: Nested Function - Receiving #DIV/0! - Need Masking Error Help

    It worked great! You rock! Thanks a bunch for your help. Deanna

  4. #4
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Nested Function - Receiving #DIV/0! - Need Masking Error Help

    You're welcome. Thanks for the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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