rounding again
 

Sorry, I've finished the previous posting. Jason gave a great formula. Thanks
very much.

But, I've just found two exceptions.

When it's 28.50 it gives us 28.45 but we need the same 28.50,
and when it's 30.45 it gives us 30.50 but we need the same 30.45.

Could we fix it somehow?

Thanks
--------------------------------------
=ROUNDUP(A1/0.05,0)*0.05

HTH
Jason
Atlanta, GA

-----Original Message-----
I need to do the following rounding in the column where
the data obtained
from calculations:
61.4111 to 61.45
68.632 to 68.65
85.85015 to 85.85
33.68 to 33.70

So, the second digit should be 0 or 5. If the second
digit was 5 it should
remain 5, if 0 and <= 5 and it should be 5, if 5 the
second digit should
be 0 but the first digit will be by 1 more.

Could anybody advise what kind of formula could I use
here?

Thanks in advance.

Sorry, guys.
I've analyzed it ones again. It looks like everything is Ok.

Thanks

"Alex" wrote:

Sorry, I've finished the previous posting. Jason gave a great formula. Thanks
very much.

But, I've just found two exceptions.

When it's 28.50 it gives us 28.45 but we need the same 28.50,
and when it's 30.45 it gives us 30.50 but we need the same 30.45.

Could we fix it somehow?

Thanks
--------------------------------------
=ROUNDUP(A1/0.05,0)*0.05

HTH
Jason
Atlanta, GA

-----Original Message-----
I need to do the following rounding in the column where
the data obtained
from calculations:
61.4111 to 61.45
68.632 to 68.65
85.85015 to 85.85
33.68 to 33.70

So, the second digit should be 0 or 5. If the second
digit was 5 it should
remain 5, if 0 and <= 5 and it should be 5, if 5 the
second digit should
be 0 but the first digit will be by 1 more.

Could anybody advise what kind of formula could I use
here?

Thanks in advance.

use
=CEILING(--(LEFT(A1,SEARCH(".",A1)+2)),0.05)
That way 85.85015 remailns 85.85 and not 85.90

"Alex" wrote in message
...
Sorry, I've finished the previous posting. Jason gave a great formula.
Thanks
very much.

But, I've just found two exceptions.

When it's 28.50 it gives us 28.45 but we need the same 28.50,
and when it's 30.45 it gives us 30.50 but we need the same 30.45.

Could we fix it somehow?

Thanks
--------------------------------------
=ROUNDUP(A1/0.05,0)*0.05

HTH
Jason
Atlanta, GA

-----Original Message-----
I need to do the following rounding in the column where
the data obtained
from calculations:
61.4111 to 61.45
68.632 to 68.65
85.85015 to 85.85
33.68 to 33.70

So, the second digit should be 0 or 5. If the second
digit was 5 it should
remain 5, if 0 and <= 5 and it should be 5, if 5 the
second digit should
be 0 but the first digit will be by 1 more.

Could anybody advise what kind of formula could I use
here?

Thanks in advance.