I\'m doing a budget sheet where I start with an amount of money and add an expen

Question

I'm doing a budget sheet where I start with an amount of money and add an expense below, then use a formula below that to get the balance. I.e.

$60

$50

$10 (formula would be =A1-A2)

I've done two columns of budgets next to it with no problem, so I know it's not the formula, but when I've tried to do the third I have a problem at the end. When the balance is zero instead of showing zero it shows -5.684E-14. When I change it to account it gives me -$0.00 when it should be just $0.00

So the sheet looks as follows:

$60

$50

$10 (A1-A2)

$10

-5.684E14 (A3-A4)

Which doesn't make any sense as again it should be zero. I've checked my formula over many times and I've even cleared all the cells and started again, but still the same result.

If I change the amounts so the answer isn't zero it's fine. Even if I leave 5 cents the balance is fine.

Anybody have any ideas??

Explanation / Answer

()*()I believe you cell A1, A2 or A4 are linked to some other cells and in calculation its picking verm small fraction of decimal.

If you will paste value those cells, then you should find some amount in decimals.

To get rid of this issue, either use roundup formula till 2 decimals at original cell or at your SUM cell.

Or try this highlight that three cells then in the ribbon under home go to the number section and click on the zeros with the arrow to your left, that will add decimals

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.