Since this discussion turns to be more and more interesting, here are my 5
cents:
Function MyRound(num, numOfDec)
tmp = 10 ^ numOfDec
num = num + (5/(tmp * 10))
MyRound = INT(num * (tmp))/ tmp
End Function
msgbox MyRound(33.666, 2)
msgbox MyRound(0.555, 2)
msgbox MyRound(9.5, 2)
msgbox MyRound(8, 2)
On Mon, Jun 8, 2009 at 2:39 PM, Srinivas Pavuluru <[email protected]>wrote:
> Some additional info.. from HP help..
>
>
> Returns the integer portion of a number.
>
> Int(number)*Fix(*number*)*
>
> The *number* argument can be any valid numeric expression. If
> *number*contains Null,
> *Null* is returned.
> Remarks
>
> Both *Int* and *Fix* remove the fractional part of *number* and return the
> resulting integer value.
>
> The difference between *Int* and *Fix* is that if *number* is negative, *
> Int* returns the first negative integer less than or equal to *number,*whereas
> *Fix* returns the first negative integer greater than or equal to *number.
> * For example, *Int* converts -8.4 to -9, and *Fix* converts -8.4 to -8.
>
> *Fix(**number**)* is equivalent to:
>
> Sgn(*number*) * *Int(*Abs(*number*)*)*
>
> The following examples illustrate how the *Int* and *Fix* functions return
> integer portions of numbers:
>
> MyNumber = *Int(*99.8*)* ' Returns 99.
> MyNumber = *Fix(*99.2*)* ' Returns 99.
> MyNumber = *Int(*-99.8*)* ' Returns -100.
> MyNumber = *Fix(*-99.8*)* ' Returns -99.
> MyNumber = *Int(*-99.2*)* ' Returns -100.
> MyNumber = *Fix(*-99.2*)* ' Returns -99.
>
>
> Thanks
>
> Srinivas Pavuluru
>
> On Mon, Jun 8, 2009 at 2:35 PM, Srinivas Pavuluru <[email protected]>wrote:
>
>> Hope you got the solution..
>>
>> On Mon, Jun 8, 2009 at 2:33 PM, Srinivas Pavuluru <[email protected]>wrote:
>>
>>> Hi
>>>
>>> To get only numbers i mean integer values
>>>
>>> you can use
>>>
>>> mvalue = "2.12"
>>> msgbox INT(mvalue)
>>>
>>> alwyas gives you the number
>>>
>>> Thanks
>>> Srinivas Pavuluru
>>>
>>>
>>> On Mon, Jun 8, 2009 at 2:29 PM, Srinivas Pavuluru
>>> <[email protected]>wrote:
>>>
>>>> Hi
>>>>
>>>> you can also try following logic
>>>>
>>>> mvalue = "2.12"
>>>> mvaluelen = len(mvalue)
>>>> mactvalue = left(mvalue,mvaluelen-1)
>>>> msgbox mactvalue
>>>>
>>>> Thanks
>>>> Srinivas Pavuluru
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, Jun 8, 2009 at 2:23 PM, Sreedhar Mallipeddi <
>>>> [email protected]> wrote:
>>>>
>>>>>
>>>>> hi
>>>>>
>>>>> use formatnumber("2.12",1) , it will give u the excepted result.
>>>>> Replace 2.12 with ur value...
>>>>>
>>>>> Thanks,
>>>>> Sreedhar
>>>>>
>>>>>
>>>>> On Mon, Jun 8, 2009 at 10:30 PM, denka <[email protected]> wrote:
>>>>>
>>>>>>
>>>>>> Hi,
>>>>>> tried to search, did not find anything like that here. Anyways, maybe
>>>>>> someone knows.
>>>>>> I have numbers with decimals like 2.13 and 2.12. Is there a way to
>>>>>> truncate decimals in those numbers? like to be 2.1. I do not need
>>>>>> rounding up. Thank you in advance
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Mallipeddi Sreedhar
>>>>> 91-9848871279
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
-~----------~----~----~----~------~----~------~--~---
