Forum Discussion
Solved
Excel is giving incorrect calculations.
I am using very simple formulas and I am getting incorrect calculations. I am not sure how to fix this. Here is my formula: =(N52-N51)/N51 (21-7)/7 = 2 or 20%. However, I am getting 183% ...
2 is not 20% but 200%.
You get unexpected results because your values are not 21 and 7 but something with a few more decimals. Change the number format to "General" to see the actual values.
2 is not 20% but 200%.
You get unexpected results because your values are not 21 and 7 but something with a few more decimals. Change the number format to "General" to see the actual values.
