1-0 = 0?!

[leele2]

Hi everyone, current stumped by a problem within my spread sheet and have no idea how to fix it and was hoping someone could guide me in the right direction.

Here's some photo's.

hNNEJVY.png

wloE425.png

I also have the same problem a few tables down in the same spot.

HwNJPHa.png

Qld1l5G.png

Thanks for reading.

[Gatti]

Can you post your Workbook?

[JBeaucaire]

What happens when you copy cell E132 and paste it onto E131?

[leele2]

Can you post your Workbook?

What happens when you copy cell E132 and paste it onto E131?

This is really bizarre but I filled in more cells to try find anymore errors and it's now showing the correct values in both cells. All I did was add values into the outlay tab.

Here's my spreadsheet if you're curious about it.

http://www.filedropper.com/test_9

[leele2]

Here's the spreadsheet clean.

http://www.filedropper.com/newtemplate_1

---EDIT---

I believe it has something to do with "Circular References" Because the clean version still shows the error.

Unfortunately I'm not too sure how to fix.

[Gatti]

You have circular references in your cels...

You have to fix it... Try to find where it is happening first and fix there

[leele2]

I've managed to fix it by just removing all the data I inputted into the test spreadsheet. It kept telling me cells where circular reference was occurring in the bottom left of excel, but I couldn't see the problem. However removing the data from the test file seems to have fixed it so I'll just quit whilst I'm ahead. Thank you for taking a look.