Good one...still u can use FormatNumber function in an vbs file or in qtp...Hope that is more easy..
On Tue, Jun 9, 2009 at 12:35 AM, Roman Zilber <[email protected]> wrote: > 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 >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>> >>> >>> >>> >> > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
