Microsoft Excell Quotient function returning a rounded value

glockshna

Distinguished
Feb 11, 2010
11
0
18,560
0
I'm trying to get the quotient of two cells using
[cpp]=QUOTIENT(E3,C3)[/cpp]

to get the profit percentage of those two cells and it's returning a rounded to the nearest 1 value. I need precise percentages. There's no formatting applied to the cell other than font and color. Any ideas?


The cells:



Buy cost Sell Return Profit Profit%

3,532.12 55,000.00 51,467.88 15

The actual number i should be getting for the last cell is 15.571 which when formatted the way i want it will display 1,571% rather than the 1,500% that it would display now. Obviously that additional 71% return is a huge difference.

Thanks!
 
Thread starter Similar threads Forum Replies Date
L Apps General Discussion 5
E Apps General Discussion 15
L Apps General Discussion 5
T Apps General Discussion 1
M Apps General Discussion 5
S Apps General Discussion 6
M Apps General Discussion 1
V Apps General Discussion 1
A Apps General Discussion 6
C Apps General Discussion 0
secretumpiratica Apps General Discussion 1
S Apps General Discussion 3
My Life Is Tech Apps General Discussion 12
My Life Is Tech Apps General Discussion 4
indyitguy Apps General Discussion 7
R Apps General Discussion 1
A Apps General Discussion 4
K Apps General Discussion 2
N Apps General Discussion 3
R Apps General Discussion 9

ASK THE COMMUNITY