Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: #DIV/0! Error

  1. #1
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,045
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-01-14 16:21, Patrick wrote:
    Can anyone tell me why this insists on bringing up the #DIV/0! Error
    =IF((E6-F6)/E6="0","",(E6-F6)/E6)
    Try:

    =IF(E6,(E6-F6)/E6,"")

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Canada
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can anyone tell me why this insists on bringing up the #DIV/0! Error
    =IF((E6-F6)/E6="0","",(E6-F6)/E6)

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,045
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    In case you didn't see any reply...

  4. #4
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-01-14 16:21, Patrick wrote:
    Can anyone tell me why this insists on bringing up the #DIV/0! Error
    =IF((E6-F6)/E6="0","",(E6-F6)/E6)
    Hi,

    Aladin already provide the solution, but the reason you are receiving a #DIV/0! error is because your test condition is comparing the result of a calculation with a string, not a number. So, the FALSE condition occurs and you return a result that divides by zero.

    Aladin's formula is much nicer, but you can achieve the same thing you want by removing the quotes around the zero.

    Bye,
    Jay

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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