| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MOD giving different results???
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? TIA, CE |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRUNC zero giving odd results? | Excel Worksheet Functions | |||
| Very large workbook now giving incorrect results :( | Excel Discussion (Misc queries) | |||
| Why isn't this macro giving me proper results? | Excel Programming | |||
| Equation giving unexpected results | Charts and Charting in Excel | |||
| GetAttr giving unexpected results | Excel Programming | |||
![Charlotte E.[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
