Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Equation Miscaculation
Hi there When I put this formating to the value of TextBoxs, Code: -------------------- Gtot.Value = Format(Gtot.Value, "#,##0.000") tot.Value = Format(tot.Value, "#,##0.000") bal.Value = Format(bal.Value, "#,##0.000") -------------------- Then the result of this line is always 1 or not correct Code: -------------------- bal.Value = val(Gtot.Value) - val(tot.Value) -------------------- How can get the correct result out of equation ? -- helmekki ------------------------------------------------------------------------ helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939 View this thread: http://www.excelforum.com/showthread...hreadid=486844 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with an equation | Excel Discussion (Misc queries) | |||
Equation Help | Excel Discussion (Misc queries) | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Need help with equation | Excel Discussion (Misc queries) | |||
Equation | Excel Discussion (Misc queries) |