Nov 13 2023 02:38 AM - edited Nov 13 2023 02:39 AM
Hi, Excel formula doesn't show the correct answer. What can be the reason? For example in the selected cell, I use average formula, answer turns out to be 0, but actually answer for first line should be 1.4, for second line it should be 3.89 and etc. There is no any mistake by my side, because I have checked it hundred times, in case any mistakes, but every time it gives zero. What can I do to get correct answer? I also use iferror function, but again same problem happens.
Nov 13 2023 02:54 AM
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?
Nov 13 2023 03:10 AM
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.
Nov 13 2023 03:44 AM
What do V74, W74 and X74 contain? Values or formulas?
If they contain formulas, what are those formulas?
Nov 13 2023 03:49 AM - edited Nov 13 2023 03:51 AM
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.
Nov 13 2023 07:14 AM
I understand that you cannot share the workbook, but I'm afraid I have no idea what causes the problem.