Ho! Sorry I didn't see about "I do not need rounding up."
Function MyNonRoundUp(num, numOfDec)
tmp = 10 ^ numOfDec
MyNonRoundUp = INT(num * (tmp))/ tmp
End Function
msgbox MyNonRoundUp(99.99, 1)
On Mon, Jun 8, 2009 at 3:00 PM, Roman Zilber <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
