Hi Roman Zilbe, Sounds good.. Keep up the good work.. Thanks Srinivas Pavuluru 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 -~----------~----~----~----~------~----~------~--~---
