Forum Discussion
Formula
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
I've tried to copy the problematic part to the new workbook, but in that workbook formula works normal, I think problem arises only in this workbook. And unfortunately this workbook contains highly confidential data. In order to describe a little bit more I've attached few more pics. For ex. Z74 cell refers to the Y74 cell and the number is 1.34, meanwhile Y74 is zero, which is not again correct number.
What do V74, W74 and X74 contain? Values or formulas?
If they contain formulas, what are those formulas?
Yes, they contain formulas, but it is just division function. For ex. V74 equals to =V48/V63 same for W74 (W48/W63) and X74 (X74/X63)
But previous cells (In the workbook we show each months separetly) also contain formulas but average or iferror function works normal for them.
