Hie, i have problem rounding down a value using VBA. Can you help?

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





-----Original Message-----
Hie, i have problem rounding down a value using VBA. Can
you help?
.

(chiajack) wrote in message . com...
Hie, i have problem rounding down a value using VBA. Can you help?

Have you tryed the =FLOOR() formula?

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.


On Tue, 28 Oct 2003 03:42:09 -0800, "Jeminar" wrote:

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





-----Original Message-----
Hie, i have problem rounding down a value using VBA. Can
you help?
.

you can use the worksheet functions:

? Application.RoundDown(1.238,2)
1.23

? Application.Floor(1.238, 0.005)
1.235



In article ,
(chiajack) wrote:

Hie, i have problem rounding down a value using VBA. Can you help?