Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi every1!!!
Need help understanding whats wrong with this function. All my variables are declared as Double. here's my code: test = Var_clStructural * 1.65 "for this example,Var_clStructural = 4.5" test=7.425 If i use the round like this: test = Round(Var_clStructural *1.65,2) I should get: 7.43, but im not and its frustrating cuz i dont see why its rounding-up like that. Can anyone point me in the right direction please!!! If i asign the 7.425 to a cell, thats formated to numbers with 2 decimal im ok,why doesnt-it work in VBA. Thx alot for your help guys!! PAtrick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problem with round down | Excel Discussion (Misc queries) | |||
Round() problem | Excel Worksheet Functions | |||
The ROUND function | Excel Worksheet Functions | |||
Round problem with sorting | Excel Programming | |||
VB Round( ) function | Excel Programming |