Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    #DIV/0! (MsOffice 97 SR2)

    I know this has been asked before but can anyone tell me how to hide the #DIV/0! .

    Thanks in advance.
    <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    If you are a fool at forty, you will always be a fool

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: #DIV/0! (MsOffice 97 SR2)

    Do some error checking in an IF:
    <pre>=IF(B1=0,"",A1/B1)</pre>

    or, more generic
    <pre>=IF(ISERROR(A1/B1),"",A1/B1)</pre>

    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: #DIV/0! (MsOffice 97 SR2)

    >if you are a fool at forty, you will always be a fool.
    <img src=/w3timages/blackline.gif width=33% height=2>

    Why didn't someone tell me when I was 39? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    -IF- the denominator will always be a number, not an #ERR, a slightly simpler way is to use the denominator as a Boolean argument to the IF, as in:

    =IF(B1,A1/B1,)
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: #DIV/0! (MsOffice 97 SR2)

    John, very nice looking albeit cryptic! I always forget that zero is false.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: #DIV/0! (MsOffice 97 SR2)

    I would like to thank you and anyone else who responded to this question.

    Thanks <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    If you are a fool at forty, you will always be a fool

Posting Permissions

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