Posted to microsoft.public.excel.programming

Don G[_2_] Don G[_2_] is offline

external usenet poster

Posts: 4

RoundDown function not working in code

I'm using Excel 2003 VBA. In the immediate window I enter

? application.rounddown(-0.775,2) and it gives the result -0.77

In the following code

'Deal with SHEETCREDIT
SheetCredit = CashIn - CashDue
'dealing with negative sheetcredit
If SheetCredit < 0 Then SheetCredit =
Application.RoundDown(SheetCredit, 2)
'display this on the form
SheetsForm.DriverCreditBox.Value = Format(SheetCredit, "currency")

SheetCredit is -0.775 and the result is -0.78 Any idea why?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Roundup and rounddown function - how to combine	RonaldoOneNil	Excel Worksheet Functions	1	May 28th 10 05:26 PM
rounddown + if function	PoetsOnMars	Excel Worksheet Functions	8	January 7th 09 02:11 PM
ROUNDDOWN Excell function	M8	Excel Worksheet Functions	4	February 13th 06 01:01 PM
Roundup / Rounddown function	GreenMonster[_2_]	Excel Programming	2	June 14th 05 09:37 PM
ROUNDDOWN function reference	dtdd	Excel Programming	4	January 14th 04 03:50 PM

All times are GMT +1. The time now is 09:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us