Q: 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
by Wayne Contello,Solvedanswer
iWork
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
Posted on Oct 6, 2014 2:53 PM