View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Patrick is offline
external usenet poster
 
Posts: 160
Default Problem with the round function

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