Share via

Excel formula answer is showing as zero

Anonymous
2018-08-30T13:57:47+00:00

The formula is simply: =B43-B44, the answer should be 1808. When I hit enter the answer shows as 0. When I input the formula through the formula wizard, the answer is shown as 1808 in the pop-up box but as soon as I hit Ok, it shows in the cell as 0.

Please help

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-09-04T00:08:17+00:00

    Hi James,

    Do you still experience this behavior? Could you please try the following step to see whether it works? Please open Excel> File> Options> Formulas> tick Enable iterative calculation.

    If you need further help, it would be better to share a sample workbook for us to test on our end. To protect your privacy, you may share it with us via Private Message.

    Regards,

    Zixuan

    400+ people found this answer helpful.
    0 comments
  2. Anonymous
    2018-08-30T14:46:18+00:00

    The problem was that there was a circular reference somewhere else in the spreadsheet, which was feeding into one of the sum cells.

    100+ people found this answer helpful.
    0 comments
  3. Anonymous
    2018-09-06T10:10:26+00:00

    Hi James,

    Please share the result when you have time. We will try our best to provide support for you.

    Regards,

    Zixuan

    20+ people found this answer helpful.
    0 comments
  4. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2018-08-30T14:24:35+00:00

    Could be due to the cell formatting.

    Please check if the cell is formatted as General and try again.

    Andreas.

    20+ people found this answer helpful.
    0 comments