S
Sena
Hi, is there a way to round up to the nearest 0.50 ?
eg: 2.23 should be rounded to 2.50 & 2.65 should get rounded to 3.00
eg: 2.23 should be rounded to 2.50 & 2.65 should get rounded to 3.00
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.
T
T. Valko
One way:
A1 = 2.23
=CEILING(A1,0.5)
A1 = 2.23
=CEILING(A1,0.5)
J
joeu2004
Hi, is there a way to round up to the nearest 0.50 ?
eg: 2.23 should be rounded to 2.50 & 2.65 should get rounded to 3.00
There may be several ways. One way:
=0.5*roundup(A1/0.5, 0)
where A1 contains the number (2.23).
Caveat: you might be surprised when "3.00" is rounded up to 3.50
because, perhaps, "3.00" is merely the rounded displayed value of
3.001, for example. The following should remedy that problem:
=0.5*roundup(round(A1)/0.5, 0)
S
Sena
Thanks it worked !
--
Cheers !
--
Cheers !
T. Valko said:One way:
A1 = 2.23
=CEILING(A1,0.5)
T
T. Valko
You're welcome. Thanks for the feedback!