+ Reply to Thread
Results 1 to 2 of 2

#DIV/0! Error

  1. #1
    Registered User
    Join Date
    03-29-2024
    Location
    Columbus, OH
    MS-Off Ver
    Microsoft 365 Versioin 2401
    Posts
    2

    #DIV/0! Error

    Hello,
    I'm having issues in that I'm receiving a #Div/0! error in my spreadsheet. The goal is to figure out what the final sick and vacation pay would be in cell B15. All green boxes are what the user would fill in and the rest are formulas. Some employees at the company have 2 positions which have 2 different rates of pay. And with that, cell E11 and E12 is the percentage of their job at that particular rate of pay. If there is someone that has one position I would take out the salary in cell B12 and the FTE in cell E12. When I do that, that is when I would receive the #DIV/0! error. Any ideas on how to fix this? Thank you!!!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,956

    Re: #DIV/0! Error

    Change your formulas to

    =IF(E12=0,0,$B$12/E12/2080)
    =IF(E12=0,0,B12/E12*1440)
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. [SOLVED] Odd Error Handling Behaviour; goes to error handler even when no error?
    By kalikj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-04-2018, 10:04 AM
  2. [SOLVED] Run-tim error -2147467259(80004005): Automation error Unspecidied error
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2014, 12:12 PM
  3. Excel macro (compile error. syntax error.) error
    By salar_younis in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-06-2014, 06:11 AM
  4. Receiving following error “Complie error : syntax error” Help
    By masond3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2012, 10:19 AM
  5. Error "run-time Error '1004': General Odbc Error
    By D4WNO77 in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-16-2012, 09:55 AM
  6. Error 75 File/Path access error, sometimes Error 1004
    By smokebreak in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-16-2011, 02:35 PM
  7. [SOLVED] Error Handling - On Error GoTo doesn't trap error successfully
    By David in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-16-2006, 02:10 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