What's new
Apple iPad Forum 🍎

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!

Ipad Numbers Question

Knightoftheapp

iPF Novice
Joined
Apr 7, 2011
Messages
446
Reaction score
15
Location
Chicago
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

iPad Fan
Joined
Jan 8, 2011
Messages
24,150
Reaction score
15,398
Location
Milton-Freewater, OR
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.

image-3962847220.jpg
 
Last edited:
OP
Knightoftheapp

Knightoftheapp

iPF Novice
Joined
Apr 7, 2011
Messages
446
Reaction score
15
Location
Chicago
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"/>



Thanks for your help.
 

Most reactions

Latest posts

Top