Rounddown problem in VBA

[chiajack]

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

 

[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

 

[CLUPE]

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

Have you tryed the =FLOOR() formula?

 

[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.

 

[J.E. McGimpsey]

you can use the worksheet functions:

? Application.RoundDown(1.238,2)
1.23

? Application.Floor(1.238, 0.005)
1.235