Rounddown problem in VBA
Hie, i have problem rounding down a value using VBA. Can you help?
|
Rounddown problem in VBA
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? . |
Rounddown problem in VBA
|
Rounddown problem in VBA
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? . |
Rounddown problem in VBA
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? |
All times are GMT +1. The time now is 11:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com