Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Simple sheet to track golf rounds. Dividing total holes by 18 to show a round. A 9 hole round shows 0. I can't get it to to show as 0.5?
iPad Mini, iOS 8.1.2
Hi Rwl,
That sound wonky to me. I can't reproduce it here. Maybe post a screenshot with your formula.
quinn
If you are using the QUOTIENT function, that is the expected result. From the Formulas and Functions User Guide:
QUOTIENT
The QUOTIENT function returns the integer quotient of two numbers. QUOTIENT(dividend, divisor)
division by zero will result and the function will return an error.
Usage Notes
(My underline, for emphasis).
If you just want to divide two numbers, use the divide operator: /
My first thought (after QUOTIENT) was that you would be using =B2/18, but your result column was too narrow to display 0.5. In Numbers '09 (and several other spreadsheet applications) a cell set to 'automatic' will display a rounded (or truncated) result showing only as many decimal places as can fit in the cell.
With Numbers 3, this does not appear to apply. The 'full' result is displayed, with only as much of the last visible digit showing as will fit within the cell boundary.
Try formatting the result cell(s) as Number, 1 decimal place.
Regards,
Barry
Thanks for the help. Prob solved. It all started when I tried to use the / for division. A + appeared so I didn't pursue it further and got involved with trying the quotient thing.
I would guess you've realized by now (after squinting) that what appears to be a + is really a ÷ .🙂 You're definitely not the first to get tripped up by that on the first encounter! Our brains are really good at filling in blank spots so we "see" what we expect to see.
SG
Looking for cell to show decimal portion of quotient.
