I need a mathematical function/formula/expression to take a number as parameter and find the lowest number ending with certain digits that is larger than the parameter. For instance, if the ending digits should be 88 these are some examples of what I want: f(0) = 0 f(87) = 88 f(88) = 88 f(89) = 188 //NB: NOT 88*2=176 f(187) = 188 f(18...
Hi Everyone, I've solved this issue but I'm just wondering why this works the way it does. I have a temporary table I am selecting from and am looking to display a a name, the number of records that match this name, and the percentage for that name of the total records. This is the way I originally had it: SELECT name, number, CASE...
Hello, I've decimal value 18.8. Values that are stored in this variable can be of any kind. For example it can be 1.0000000 or 1.00004000 or 5.00000008. I would like to write a method so that i can pass decimal to it and get rounded up string. This wouldn't be a problem if i would know decimal places i would like to get. But what i wou...
How do I prevent my double value from being rounded when converting to a string? I have tried both Convert.ToString and ToString() with the same result. For example my double may look something like 77.987654321, and the two strings conversions convert to to 77.98765. I need to keep the precision of the value as is. ...
Hi, I'm trying to figure out how to round a monetary amount upwards to the nearest 5 cents. The following shows my expected results 1.03 => 1.05 1.051 => 1.10 1.05 => 1.05 1.900001 => 1.10 I need the result to be have a precision of 2 (as shown above). Update Following the advice below, the best I could do is this B...
Lets say I divide 14 / 15 times it by 100 to get the percentage which is 93.33333333333333 how can I display it as 93.3% using php? Here is the code. $percent = ($avg / 15) * 100; ...
The following code currently outputs: 12.1 12.100 12.1000 12.00 12 12.0000 How can I change it so it outputs: 12.1 12.1 12.1 12 12 12 Math.Round seems to be the thing, but it makes me define how many decimal places I want, but I want them to be variable as above. If there is no mathematical way to do it, I'll just strip the zeros ...
I want a rounding method on double values in C#. It needs to be able to round a double value to any rounding precision value. My code on hand looks like: public static double RoundI(double number, double roundingInterval) { if (roundingInterval == 0.0) { return; } double intv = Math.Abs(roundingInterval); d...
If I have a decimal, how do I get a string version of it with two decimal places? This isn't working: Math.Round(myDecimal, 2).ToString("{0.00}"); ...
Hi I have this line: for (var j = 0; j<1; j = (j + 0.1).toPrecision(1)) I'm trying to set up this statement so I get 0, 0.1, 0.2, 0.3 up to the number 1. At the moment I get 0, 0.1 and then nothing as if the result goes straight passed 1, Simply using j = j + 0.1 produces rounding errors and I need the precise decimal place. Any s...
I have a DATE column that I want to round to the next-lower 10 minute interval in a query (see example below). I managed to do it by truncating the seconds and then subtracting the last digit of minutes. WITH test_data AS ( SELECT TO_DATE('2010-01-01 10:00:00', 'YYYY-MM-DD HH24:MI:SS') d FROM dual UNION SELECT TO_DATE('2010-0...
Hi, I have a requirement to resize all the controls on a form when my form resizes. Unfortunately, due to some issues I can not use any container control or make use of anchor/dock property. I need to do everything using code. I am able to resize the controls as per the ratio the screen is resized. While performing this resizing, I need ...
Hi, How to round decimal value up to nearest 0.05 value??, the linked SO post also discusses the similar topic, but its not the output i expected. I need to convert the decimal values like this 16.489-->16.49 16.482-->16.48 16.425-->16.43 7.67 --> 7.67 (no conversion) I can use the below C# method to convert the values Math.Round...
in JavaScript, the typical way to round a number to N decimal places is something like: function round_number(num, dec) { return Math.round(num * Math.pow(10, dec)) / Math.pow(10, dec); } However this approach will round to a maximum of N decimal places while I want to always round to N decimal places. For example "2.0" would be r...
I've noticed the following inconsistency in C#/.NET. I was wondering why it is so. Console.WriteLine("{0,-4:#.0} | {1,-4:#.0}", 1.04, Math.Round(1.04, 1)); Console.WriteLine("{0,-4:#.0} | {1,-4:#.0}", 1.05, Math.Round(1.05, 1)); Console.WriteLine("{0,-4:#.0} | {1,-4:#.0}", 1.06, Math.Round(1.06, 1)); Console.WriteLine("{0,-4:#.0} | {1,...
Assume I do this operation: (X / const) * const with double-precision arguments as defined by IEEE 754-2008, division first, then multiplication. const is in the range 0 < ABS(const) < 1. Assuming that the operation succeeds (no overflows occur), are distinct arguments of X to this operation guaranteed to return distinct results? I...
As we all know, floating point arithmetic is not always completely accurate, but how do you deal with its inconsistencies? As an example, in PHP 5.2.9: (this doesn't happen in 5.3) echo round(14.99225, 4); // 14.9923 echo round(15.99225, 4); // 15.9923 echo round(16.99225, 4); // 16.9922 ?? echo round(17.99225, 4); // 17.9922 ?? ...
I'm making a game with Python->PyGame->Albow and ran into a problem with board generation. However I'll try to explain the problem in a language agnostic way. I believe it's not related to python. I've split the game board generation into several parts. Part one generates the board holes. Holes are contained in a list/array. Each hole...
Is there a build-in function that can round like this: 10 -> 10 12 -> 10 13 -> 15 14 -> 15 16 -> 15 18 -> 20 ...
Hello, I have this (row and count are parameters): (int)Math.Round(count / (decimal)rows, MidpointRounding.AwayFromZero) if the result is 1.2, I'd lire return 2; 5.6 ---> 6; 79.9 ---> 80; 85.01 ---> 86 All the time the unit above, an int, not decimal. An idea ? Thanks, ...