+ Reply to Thread
Results 1 to 4 of 4

how to resolve #DIV/0! error on actual data basis

Hybrid View

  1. 02-23-2016, 02:38 PM #1
    roofi
    roofi is offline
    Forum Contributor
    Join Date
    06-07-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    167

    how to resolve #DIV/0! error on actual data basis

    Dear Experts
    Attached is my worksheet. i want to resolve green highlighted errors.
    result should be the actual as others not "0".

    regards,
    Roofi
    Abdul Rouf Roofi
    Reply With QuoteRegister To Reply
  2. 02-23-2016, 02:49 PM #2
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,773

    Re: how to resolve #DIV/0! error on actual data basis

    No worksheet attached.
    Reply With QuoteRegister To Reply
  3. 02-23-2016, 02:55 PM #3
    roofi
    roofi is offline
    Forum Contributor
    Join Date
    06-07-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    167

    Re: how to resolve #DIV/0! error on actual data basis

    Please find attachment
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 02-23-2016, 04:52 PM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,897

    Re: how to resolve #DIV/0! error on actual data basis

    In the case of G9 it would seem that the calculation is 6/0 what is it that is expected to go in that cell if not #DIV/0? If you just want zero in the cell then modify the formula in G9 to: 
    =IFERROR(((D9+1)-A9)/A9,0)
    Change the others similarly so that they read =IFERROR(...,0)
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How can I resolve this VLOOKUP #REF error?
    By Nate Westcott in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-14-2015, 07:26 AM
  2. [SOLVED] Help to resolve Run time Error 380
    By LenaK in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-30-2015, 11:55 AM
  3. [SOLVED] Can't resolve PivotTable Property error.
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-07-2014, 12:27 PM
  4. Unable to resolve Runtime error 91
    By jr2007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2013, 07:37 AM
  5. Need to allocate budget on a per month basis vs actual
    By joshgumby87 in forum Excel General
    Replies: 7
    Last Post: 03-11-2013, 08:10 AM
  6. Add ISERROR to resolve DIV/0 error
    By mtntxn in forum Excel General
    Replies: 2
    Last Post: 09-28-2009, 04:58 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1