SOLVED

# Excel is giving incorrect calculations.

Copper Contributor

# 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%

Same here even though I tried the formula differently: =(F52-F51)/F51*1  (20-18)/18X1 =.11 or 11%.  However, I am getting 14%.

How do I fix this?

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Excel is giving incorrect calculations.

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.

# Re: Excel is giving incorrect calculations.

Typo!  It is 200%

I see what you're saying and get it!  Man, four hours wasted.

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Excel is giving incorrect calculations.

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.