How do I round numbers derived from a percentage formula?

Question

Level 1

4 points

How do I round numbers derived from a percentage formula?

I am creating an estimate sheet in Numbers '09. I have a combination of hard numbers and percentages of numbers (sub totals, etc.) in my estimate column. I would like to know how , based on a percentage formula such as =(D23*0.12), I can control the actual figure through rounding up or down (either .00 decimals or into the 000's). Is there a rounding formula attached to this percentage formula or somehow an extension of the percentage formula?

Thank you

Mac mini, Mac OS X (10.6.8)

Posted on Apr 18, 2012 12:50 PM

Reply

Answer 1

Apr 18, 2012 12:56 PM in response to Hyrax

If you want to affect the display only, use the Cells Inspector to adjust the format.

If you want to change the data, use the ROUND function, or its cousins MROUND, ROUNDUP and ROUNDDOWN.

Jerry

Reply

Answer 2

Hyrax Author

Level 1

4 points

Apr 18, 2012 1:49 PM in response to Jerrold Green1

Thanks for the quick reply - do the ROUND, MROUND, ROUNDUP and ROUNDDOWN work with an existing cell's formula (the percentage one mentioned above)? If yes, how does a string of this look?

Reply

Answer 3

Hyrax Author

Level 1

4 points

Apr 18, 2012 2:54 PM in response to Hyrax

OK, I'm getting how this works:

If the formula "=(D24*0.12)" yields $10,184.00 and I want to ROUNDUP to the nearest 100, the formula works like this "=ROUNDUP(D24*0.12, -2)" with the "-" identifying the number of digits to the left of the decimal point to replace with zeros (the number of zeros at the end of the number). In this example $10,184.00 becomes $10,200.00.

If there are any other tricks here, I'd love to hear more. Thanks in either case.

Reply

Answer 4

Barry

Level 9

60,023 points

Apr 18, 2012 8:13 PM in response to Hyrax

Hi Hy,

I don't understand why you would want to display the two zeroes after the decimal point in a number that has been rounded to the hundreds place.

Here's the result of your formula with cell format left at Automatic. C2 contains your formula (revised to refer to the cell in column B, rather than D24); C3 contains the same formula without ROUNDUP applied.

C2: =ROUNDUP(B2*0.12, -2)

C3: =B3*0.12

Regards,

Barry

Reply