Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to get this formula to work in my macro, but it seems not to
accept the MROUND, I get a Sub or Function not defined error. I need the MROUND so that I can get proper rounding results. The formula below is working with times and without MROUND I sometimes get rounding errors. For example: 15:21 - 15:00 returns .35 which should round to .4 but rounds to .3 TextBox10.Text = Format(Round(MROUND((CDate(TextBox9.Text) _ - CDate(TextBox8.Text)) * 24), 1), "#.0") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using a defined Name in a function | Excel Worksheet Functions | |||
Sub or function not defined | Excel Worksheet Functions | |||
sumproduct function / VB user defined function | Excel Discussion (Misc queries) | |||
Max of a defined function | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |