Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding numbers up or down | Excel Discussion (Misc queries) | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
Can I stop rounding in excel? | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
Price rounding - exception formula required | Excel Worksheet Functions |