C
chiajack
Hie, i have problem rounding down a value using VBA. Can you help?
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.
J
Jeminar
rounding down a number to the integer
<rounded down>=INT(number)
rounding down a number and rounding up a negative
<rounded down>=INT(number+SGN(number)/2-0.5)
rounding to somethign other than an integer
<rounded down to 1dp>=INT(number*10)/10
using round function
<rounded down>=application.round(......)
application.command(...) accesses the excel formulae
<rounded down>=INT(number)
rounding down a number and rounding up a negative
<rounded down>=INT(number+SGN(number)/2-0.5)
rounding to somethign other than an integer
<rounded down to 1dp>=INT(number*10)/10
using round function
<rounded down>=application.round(......)
application.command(...) accesses the excel formulae
C
CLUPE
Hie, i have problem rounding down a value using VBA. Can you help?
Have you tryed the =FLOOR() formula?
M
Myrna Larson
There's a problem with your 2nd formula. If Number = -3892.1, it gives -3894. If Number = 0, the
result is -1.
To round a positive number down and a negative number up, you can use FIX, i.e.
=FIX(Number)
You can also use the worksheet functions ROUNDUP and ROUNDDOWN, as well as ROUND.
With Number = -3892.1, Fix, Round, and RoundDown all give -3892. RoundUp gives -3893.
result is -1.
To round a positive number down and a negative number up, you can use FIX, i.e.
=FIX(Number)
You can also use the worksheet functions ROUNDUP and ROUNDDOWN, as well as ROUND.
With Number = -3892.1, Fix, Round, and RoundDown all give -3892. RoundUp gives -3893.
J
J.E. McGimpsey
you can use the worksheet functions:
? Application.RoundDown(1.238,2)
1.23
? Application.Floor(1.238, 0.005)
1.235
? Application.RoundDown(1.238,2)
1.23
? Application.Floor(1.238, 0.005)
1.235