MOD giving different results???
Charlotte E. wrote:
When I wrinte this worksheet function in a spreadsheet:
= MOD ( -11993.4 , 29.53058867 )
...I get 25.55 - which is what I want...
...but if I do the same in VBA:
MsgBox -11993.4 Mod 29.53058867
...I get -23 !!!
How come MOD provides different answers, depending on if you're using it
in a spreadsheet or in a VBA-code???
How to make the VBA-code provide the result, that I want?
because these are two different functions just sharing the same name :)
another example
try trim in excel and trim in vba.
and use " aaa bbb " as example
|