Rounding 0,99 up to 1?

[derkeherk]

Hello. Im wondering how you round up the number 0,99 to 1. i can see change the maximum decimals in the number format window, but how do i only make it round up 0,99 to 1, and not for example 0,44 to 0,45 and 0,33 to 0,2? also, so it automatically finds out that 0,99 + 0,33 does not give 1,32.

so basically dont round up numbers unless its 0,99. how do i do that? im using the 2013 version

as you can see below, i made a simple list using the =SUM formular.
2
16
-3
-7
-2,66
-2,33
0,44

18 Starting
-14,55 Outcome
3,45 Remaining

(for example this 0,66 + 0,33 = 1 + 0,44 = 1,44) and not 1,43.
is that possible?

Thank you for your time

[JesMath]

Do I get it right, that you want to round it up, if the last digit is above a certain value?

if yes, this should work:
=IF((RIGHT(D2,1)+0)>5,ROUNDUP(D2,0),D2)

In D2 is your value, and this rounds up everything with a larger last digit than 5 to the next integer so:
0.14 = 0.14
0.15=0.15
0.16=1

[JazzKult]

How about something like this? It will round up the value in cell A1 if the decimal is 0.99 or greater.

Please Login or Register  to view this content.