/ Sign-up
Your question

Microsoft Excell Quotient function returning a rounded value

  • Office
  • Microsoft
  • Apps
  • Displays
Last response: in Apps General Discussion
April 1, 2011 10:08:54 AM

I'm trying to get the quotient of two cells using
  1. =QUOTIENT(E3,C3)

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.


More about : microsoft excell quotient function returning rounded

April 1, 2011 10:12:22 AM

Nevermind, Just realized i can just use =E3/C3. Derp.

Close please?