+ Reply to Thread
Results 1 to 6 of 6

newbie here problem with div/0!

  1. #1
    Registered User
    Join Date
    07-21-2014
    Location
    philippines
    MS-Off Ver
    2007 & 2010
    Posts
    3

    newbie here problem with div/0!

    i try to make a spreadsheet, which is attached, but when i try to input none value to c21 & d21 i get this div/o! error, how to elimate this error if i dont put any entry to said cels? thanks
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,749

    Re: newbie here problem with div/0!

    Hi and welcome to the forum

    Try this...
    =IF(D21="","",(C21/D21)/24)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-21-2014
    Location
    philippines
    MS-Off Ver
    2007 & 2010
    Posts
    3

    Re: newbie here problem with div/0!

    still having problems there is an error stating after D21=

    e21=(c21/d21)/24 is what i like to happen
    what if there is no input (empty data) for c21 & d21 to avoid div/0 error, to complement the table

    thanks

  4. #4
    Registered User
    Join Date
    07-21-2014
    Location
    philippines
    MS-Off Ver
    2007 & 2010
    Posts
    3

    Re: newbie here problem with div/0!

    still having problems there is an error stating after D21=

    e21=(c21/d21)/24 is what i like to happen
    what if there is no input (empty data) for c21 & d21 to avoid div/0 error, to complement the table

    thanks

  5. #5
    Registered User
    Join Date
    07-21-2014
    Location
    philippines
    MS-Off Ver
    2007 & 2010
    Posts
    3

    Re: newbie here problem with div/0!

    E21=(d21/c21)/24

    d21 & c21 = no value in-putted
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: newbie here problem with div/0!

    You better not post an Word.doc on an excel forum.

    If you try to understand the formula in #2 of FDibbins, I bet your problem is solved.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  7. #7
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,138

    Re: newbie here problem with div/0!

    this should work for you...
    in cell I21 =IFERROR(IF(H21="LS",((C21/D21)*(G21/24)),0),0)
    in celll E21 =IFERROR((C21/D21)/24,0)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Newbie problem
    By catcher24 in forum Excel General
    Replies: 1
    Last Post: 02-17-2007, 02:46 PM
  2. Newbie with problem (duh!)
    By opopanax666 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-06-2006, 10:48 AM
  3. Newbie VBA Problem
    By FCC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-02-2006, 12:50 PM
  4. Newbie problem :(
    By Liosan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-15-2005, 10:05 AM
  5. Newbie Problem
    By BuddyB in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2005, 10:21 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1