M
Mary
Hi I want to round up a number only if the decimal part is greater than 0.25,
if not leave it as a whole number
Thank you.
if not leave it as a whole number
Thank you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Round up a number to what, next integer?
--
Regards,
Peo Sjoblom
--
Regards,
Peo Sjoblom
D
Duke Carey
=if(mod(a1,1)>.25,int(a1)+1,a1)
If A1 = 2.3, that formula will give you 3
If A1 = 2.2, that formula will give you 2.2
If you want 2.2 to be turned into 2.0, then use
=if(mod(a1,1)>.25,int(a1)+1,int(a1))
If A1 = 2.3, that formula will give you 3
If A1 = 2.2, that formula will give you 2.2
If you want 2.2 to be turned into 2.0, then use
=if(mod(a1,1)>.25,int(a1)+1,int(a1))
H
Harald Staff
=ROUND(A1+0.245,0)
HTH. Best wishes Harald
HTH. Best wishes Harald
M
Mary
Thank you so much Duke. It worked.
Duke Carey said:=if(mod(a1,1)>.25,int(a1)+1,a1)
If A1 = 2.3, that formula will give you 3
If A1 = 2.2, that formula will give you 2.2
If you want 2.2 to be turned into 2.0, then use
=if(mod(a1,1)>.25,int(a1)+1,int(a1))