Percentage Formula

[eramirez148]

I am having issues populating the correct percentage. This is breaking my head. I entered the following formula to calculate the percentage "=SUM(A14-B14)/A14" in the first row it seems like the percentage is correct. However in the second row the percentage is off by .1 is there a reason to this?

A	B	C
100​	90​	10%​
90​	100​	-11%​

 

[Fluff]

Try increasing the number of decimal places the cell shows

 

[eramirez148]

A	B	C
100​	90​	10.00%​
90​	100​	-11.11%​

 

[Candyman8019]

For percentage, wouldn't you always want to divide by 100% rather than B14

 

[eramirez148]

For percentage, wouldn't you always want to divide by 100% rather than B14

You are right . Its been a long day lol thank you!

 

[Candyman8019]

Happy to help...