I need to get 2 decimal places when using a formula for a quotient and Numbers will only give me whole integers which is useless since most items will be less than 1. How can I change this?

Question

Level 1

0 points

I need to get 2 decimal places when using a formula for a quotient and Numbers will only give me whole integers which is useless since most items will be less than 1. How can I change this?

How do I get 2 decimal places when using a formula for a quotient? It only gives me whole integers. Most of the results will be less than 1 so I need 2 decimal places

MacBook Pro (Retina, 15-inch, Late 2013), OS X Mavericks (10.9.4)

Posted on Oct 6, 2014 2:12 PM

Reply

Answer 1

Oct 6, 2014 2:53 PM in response to francynew

the quotient function returns only whole number portion of the dividing two numbers. If you want the actual decimal value use the divide operator. you enter this as:

A/B

if the numerator is in A1 and the denominator is in B1 you can enter the formula like this:

=A1/B1

Reply