Forum

  • If you are new to these Forums, please take a moment to register using the fields above.

Announcement

Announcement Module
Collapse
No announcement yet.

Excel format #DIV/0! to blank

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel format #DIV/0! to blank

    Hello, does anyone know how to in excel format cells that have #DIV/0! to a blank without using the ISNA command? Thank you

  • #2
    try this: http://support.microsoft.com/?kbid=154874

    Tom

    Comment


    • #3
      I've always handled that by prefacing my math with an if statement, something like =if (C1<>0, D1/C1,0), to check to see if I was actually trying to divide by zero. That may or may not be feasible depending upon how you have your function nested, but I'm always a little leary of just globally hiding errors.

      Comment


      • #4
        Reply

        Hi Thanks.. I shall try it

        Comment

        Working...
        X