Dividing with decimals in Numbers -- how?

I can't find an answer to a simple question -- can Numbers not divide decimals?

I insert a standard quotient formula into the cell and the result is a whole number. It doesn't even round to the nearest whole number.

Am I using it wrong? Or using the wrong tool for the job, here?

Posted on Jun 11, 2024 10:08 AM

Similar questions

Numbers Formula to convert decimal values to fractions, then round them to nearest 32nd of an inch In Numbers, I know I can simply copy and paste a column of decimal values into another column and use Formatting to get them to the nearest 16th, but I need the result to be rounded to the nearest 32nd of an inch, which is not offered in Numbers. eg: 4.89 = "4~28/32" (and then reduced to "4 ⅞"). So I must use a formula instead. I'm looking for the complete syntax for the formula, since partial answers are plentiful on the internet. I need to be able to insert the formula in a new column and have it work it’s magic on the decimal entries in a different column. Have searched and searched and not found a single, sensible answer anywhere. Help somebody!!
935 5
Wrong calculations in Apple Numbers. As in the screen shot i have same (numbers) format in the row, however when i multiply the highlighted i did not get the right answer. I have set 2 decimal for all the cells and the format for all is also same but still not getting the right answer. How to fix this error ?
540 11
How do I specify number of decimal places for a programmed formula? For example, I want the formula “Answer is: “& (A1/B1) in cell C1 and I want to limit the resulting display in C1 to two decimal places after the text component.
275 2

1 reply

KRosey11 Author

Level 1

4 points

Jun 11, 2024 10:15 AM in response to KRosey11

I figured it out. Don't use the quotient formula, just open the formula menu in the cell and use the / between your two numbers.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Dividing with decimals in Numbers -- how?

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up