Forum Discussion
Formula
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.
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?
