Knightoftheapp
iPF Novice
I'm having trouble with the Numbers app for my iPad 2. Can someone please tell me how to round numbers up or down?
Welcome to the Apple iPad Forum, your one stop source for all things iPad. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
twerppoet said: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"/>