Hi Guys, can find a simple solution to this:
How to round up and answer derived from a simple division, multiply, add, etc. formula with a rule : round up to the one's (no matter the value) in Apple Numbers??
Thanks in advanced
MacBook Pro (15-inch Late 2011), OS X Yosemite (10.10.3), null
The Ceiling formula would be what you are looking for. Read the information in the formal bar to help.
The Ceiling formula would be what you are looking for. Read the information in the formal bar to help.
tried it and worked, but i cant seem to get the trailing numbers to disappear...
for eg.
I would like 3.1425 to round up to a whole number which would be 4.
its showing 4.1425 with the Ceiling Function.
oh I just removed the decimals in the data format section. đ
thanks
I am not sure if you have it figured out. if you want 4.1234 in cell A1, to rounded up to the nearest integer 5, then your formula should be something like
Ceiling(A1,1), where 1 round the cell up to the closest integer. If you were to put a 2, then this example would run up to 6.
Just because you don't see them on your sheet they would still be there. I am not sure why the function is working properly. You should be able to have infinity numbers after the decimal, and it round it up to an even number. Please let me know if you are having problems.
Hi Sean,
"oh I just removed the decimals in the data format section."
Reformatting a number to not DISPLAY the digits after the decimal does not change the value of that number. If you use it in further calculations, that value, not the displayed value, is what is used in those calculations.
There are two functions that will adjust the value (not just the format) of a calculation result to fit your needs.
CEILING has already been mentioned. The other is ROUNDUP. Here's a sample.
Column A contains a seed number. Column B contains the result of a calculation using that number. The result is displayed to 15 places, the limit of displayed precision for calculations in Numbers, but is actually stored to a slightly finer precision.
Columns C and D show the results of applying CEILING or ROUNDUP to the number in column B.
Formulas:
B2: =CEILING(B,1)
The "1" here means 'take it up to the nearest multiple of 1'
C2: =ROUNDUP(B,0)
The "0" here means 'round it up to the nearest value with no significant digets after the decimal.'
Note that no special formatting has been applied to columns C and D.
Regards,
Barry
round up an answer
