Ipad Numbers Question

[Knightoftheapp]

I'm having trouble with the Numbers app for my iPad 2. Can someone please tell me how to round numbers up or down?

 

[twerppoet]

In a data entry cell, or a formula cell?

In the data entry cell, all you can do is control the number of decimal points to be shown. Rounding will occur by the normal rules, but this only affects the display. The full number is preserved for computations.

There are about 10 functions that can be used to round in a formula cell. The simplest of these, and the ones you probably want, are the ROUNDUP and ROUNDDOWN functions.

 

[Knightoftheapp]

In a data entry cell, or a formula cell?

In the data entry cell, all you can do is control the number of decimal points to be shown. Rounding will occur by the normal rules, but this only affects the display. The full number is preserved for computations.

There are about 10 functions that can be used to round in a formula cell. The simplest of these, and the ones you probably want, are the ROUNDUP and ROUNDDOWN functions.

<img src="http://www.ipadforums.net/attachment.php?attachmentid=27338"/>

Thanks for your help.

 

[twerppoet]

No problem.