how to round off 2.30 as 3 same way 2.15 as 2

Question

Javed Ali · Answer

var roundedA = Math . Round ( 1.1 , 0 ); // Output: 1 var roundedB = Math . Round ( 1.5 , 0 , MidpointRounding . AwayFromZero ); // Output: 2 var roundedC = Math . Round ( 1.9 , 0 ); // Output: 2

Rafnas T P · Answer

hi @siva nathan, try below got it will work fine here create function as below and pass your value as string to this function for example, string _Value = "2.30" ; _Value = RoundOf(_Value); //ex1 string _Value = "2.15" ; _Value = RoundOf(_Value); //ex2 function is as follows private static string RoundOf( string _Value) { string [] _Valuesplit = Convert.ToDouble(_Value).ToString( "F2" ).Split( '.' ); int _intValue2 = Convert.ToInt16(_Valuesplit[1][0].ToString()); if (_intValue2 >= 3) { _Value = Math.Ceiling(Convert.ToDouble(_Value)).ToString(); } else { _Value = Math.Floor(Convert.ToDouble(_Value)).ToString(); } return _Value; }

Javed Ali · Answer

public static long RemCalculate(decimal n) { long number = (long)n; long s,t = 0, r, d; s = number / 1000; // t= t* 10 + s; r = number % 1000; if (r >= 500) { d = s * 1000 + 1000; } else { d = number - r; } return d; }

Nitin Sontakke · Answer

@Karthi, this is precisely what I had said in my post earlier. http://www.c-sharpcorner.com/forums/how-to-round-off-2301-as-24-in-sql-server @Siva, if you ask questions without disclosing your intensions, you will keep on getting technically correct answers, in most of the cases they are useless. If you want to know what I mean by technically correct answer, read the joke "High Flying PM" at following link: http://www.cvr-it.com/PM_Jokes.htm May be you have read it before!

Karthi Keyan · Answer

I tried my self. i am also can't get. becz round off is a math function. based on maths 2.50 can be converted to 3, if thats 2.49 then that might be 2. you can't change the built in function's. so you should write the code by own to get that output.

siva nathan · Answer

roundoff function is not working select round('02.35',0) as Hr while roundoff this value im getting only 2 my expecting answer is 3 bcoz 2.30 means 3 and 2.29 is 2

Karthi Keyan · Answer

@Siva, Is The Value Always same? if yes then use condition to round off.