Re: "Round" not found

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: FxM (fxmanceaux_at_chello.fr)
Date: 05/22/04 

Date: Sat, 22 May 2004 22:45:58 +0200

> Hi Alan,
>
> As said by other eminent colleagues round is missing under XL97.
> Try :
>
> public function round97(nb,dec)
> round97 = int(nb*(10^dec)+0.5)/(10^dec)
> end function

Some rounding problems I prefer not to look at ... Seems better with :
round97 = (Int((nb * (10 ^ dec)) + 0.5 + (10 ^ (dec - 4)))) / (10 ^ dec)

HTH
FxM

Relevant Pages

  • Re: C# COM call with Optional Parameter
    ... variant, then you would pass the value of System.Reflection.Missing.Value to ... to indicate it is truly missing. ... > Public Function GetTasks(Optional ByVal lngUserCode As Long) As> ADODB.Recordset ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Set the value of a variable using a variable
    ... Hmm, I don't see how this will "modify" the value of any variable you send to it, am I just missing it? ... "Cor Ligthert" wrote: ... > Public Function calculateAs Integer ...
    (microsoft.public.dotnet.languages.vb)
  • Re: [PATCH] Export ata_scsi_simulate() for use by non-libata drivers
    ... That you are defining a public function in multiple files should be a ... hint that something is still missing... ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Class functions not showing
    ... I created a new class in my App_Code folder and added a public function. ... David ...
    (microsoft.public.dotnet.framework.aspnet)