×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Getting rif of #DIV/0!

Getting rif of #DIV/0!

Getting rif of #DIV/0!

(OP)
Hi all,

I picked up a good tip for suppresing 0's in blank cells and it worked a treat. (0.00;;)

Does anyone know if it's possible to get rid of the #DIV/0! in a cell.  I know what's causing it, but dont want it displayed on my spreadsheet with no input.

Thanks in advance for any help.

RE: Getting rif of #DIV/0!

You can use an If statement to see if the denominator is zero. If so, set the cell to an empty string otherwise display the result.

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

RE: Getting rif of #DIV/0!

One way of removing the DIV/O result is to use the IF and ISERROR functions in a combination, NB this also works for all error results.

=IF(ISERROR(A1/A2),0,A1/A2)

where A1 and A2 are the respective cell references (substitute your own formula)

RE: Getting rif of #DIV/0!

(OP)
warburton1,

Your IF and ISERROR solution worked like a charm. All I changed was replacing the 0 with "" to display a blank cell rather than a zero. Now my blank template looks good!

Thanks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources