Results 1 to 2 of 2

Thread: Getting div-error

  1. #1
    holo man
    Guest holo man's Avatar

    Getting div-error

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am want to return the formulae value to "-". It is below

    D11 cell = 10
    F11 cell = 59,000

    I am calculating increase in expense wherever D11-2011 EXPENSE and F11-2012 EXPENSE

    formulae is =SUM(F11-D11)/D11 that returns #Div/0! Error

    Please help it is my very old problem.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    It gives 5899 for me, not #Div/0.

    BTW, it doesn't need sum, just


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts