Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I would like to create a macro that can help me to compare the 1st decimal point of floating numbers in a data list; then round up the number based on the condition below:- - if the 1st decimal point of the number(s) is .3, for example 2.3 / 8.3 / 7.3; then the numbers will be rounded to 3 / 9 / 8 respectively. -if the 1st decimal point of the number(s) is other than .3, for example 4.1 / 5.8 / 9.3; then the numbers will be rounded to 4 / 5 / 9 respectively. I can get the macro done with If...Then... Else control structure but I can't get the macro to specifically check the number(s) using the 1st decimal point. So, anyone has any ideal how to solve this problem??? Advise is needed over here..... Thanking in advanced. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
decimal point in general number | New Users to Excel | |||
starts with decimal point only if number is like 0.###... | Excel Worksheet Functions | |||
Check if there is a decimal point | Excel Programming | |||
Floating point number comparison | Excel Programming | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) |