Excel formulas computing zero

Question

Hello all,

I am creating financials for a company for my school course. I have cells referencing others sheets/cells. My formulas all worked perfectly, but then one day everything broke. Some of my formulas are still intact, but if I click in the cell with the formula / F2, it computes a zero value (gives me a dash - ). I don't have any advanced formulas in here. I attached the Excel for reference. I also tried copying the sheets into a new workbook, but same result. I need help ASAP, my presentation is due in a few days.

Thank you for any feedback.

(I am on Windows Excel!)

Answer 1

You are welcome.

Answer 2

It worked! Thank you so much!!

Answer 3

Hi,

there is a circular reference in cell N7 of the Income statement worksheet. In cell N7, the formula should be:

=SUM($E$7,$H$7,$K$7)/SUM($E$6,$H$6,$K$6,$N$6)*N6

This should work.

Answer 4

https://1drv.ms/x/c/9d1c7f46ef19fd6b/ETMciSGklVZCgtKl3s25xr4BJVOSurjRdONot8FFjXiLpg?e=4gdMvs I can't attach attachment, but here is a link - thank you for the reply!

Answer 5

Hi,

Share the download link of the MS Excel file and show the problem there very clearly.