o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Rounding to nearest 25,000 -

This is not an ordinary rounding issue. Here's what I need to do. I have to round any number up to the nearest 25,000 increment.

For example:

124,698 would need to round to 125,000
126,125 would need to round to 150,000
1,278,189 would need to round to 1,300,000

Anyone know of a mathematical formula for doing this? Or any good ideas as to how to accomplish this? THANKS!

 

Rounding to nearest 25,000 -
This is not an ordinary rounding issue. Here's what I need to do. I have to round any number up to the nearest 25,000 increment. For example: 124,698 would need to round to 125,000 126,125 would need to round to 150,000 1,278,189 would need to round to 1,300,000 Anyone k

Round to nearest 0.25 -
I saw rounding to the nearest 5 here. I tried that method to round to the nearest 0.25, but it gave me a divide by zero error. Is there any other way to round to the nearest 0.25? Thanks.

Rounding off to the Nearest 5 in VB6 -
I have a currency amount that I always want to round off the the nearest 5. I would like the currency amount to round off downwards to the nearest five. Eg. $459 = $455 Eg. $456 = $455 Eg. $451 = $450 Eg. $454 = $450 ie. going down to the nearest 5. I am not at all experi

Rounding down to nearest nickel -
Is there a vb function that would allow me to round down to the nearest nickel or should I just write something that will change it as a string?

rounding to the nearest whole five -
Hi Everyone, I am wondering if anyone would know how to round a number to the nearest whole 5. I saw an example code online somewhere of being able to do it using the round() function but I cant find it. Thanks everyone for the help!

Silly question (Rounding) -
Have searched as always but it appears all the rounding done if for numbers like 10.34354 etc I need to round off to the nearest 10 but not least, example 10 would stay as 10 11 would be 20 3 would be 10 22 would be 30 Thanks in advance

**RESOLVED** Rounding to the nearest whole number -
Hi I need help! I have conducted a search on this forum and have found nothing.... what I need help with is rounding to the nearest whole number ??? i.e 1.5 becomes 2.0 1.4 becomes 1.0 etc etc Your help and time is very much appreciated

Rounding to nearest .25 -
Hi, I'm looking for a way to automatically round numbers and times to the nearest .25. Right now I'm simply checking the numbers. e.g. if the decimal portion <> 00 or .25 or .50 or .75 then show a message box telling the user to round the input. Likewise, minutes are checked fo

[2008] Rounding to the nearest half (0.5) -
Hey guys, I am reading the temperature of a device and the values are rounding to 1 decimal place. For example, right now it's 13.8 degrees. What I want to do is round to the nearest half of a degree, so using the 13 degree mark as an example:13.1, round to 13.0 13.2, round to 13.0

Easy date/time rounding Q. ***RESOLVED*** -
Hi I'm trying to find the most efficient way of rounding time values to the nearest hour. Eg "19:41:00" should read "20:00:00" Any pointers anyone? Thanks in advance.

Rounding - Does it or doesn't it -
I've seen a few comments on this forum that suggest the round function only rounds to the nearest even number. Is this really the case? I've tried a few experiments and, for me at least, this doesn't appear to be true. ie: round(10.6) produces 11 (not even!) print round (11.12

Int - converting to integer -
Does Int always round down to the nearest integer? I run a program and it will convert, say 15.9999, to 15 or 100.9999 to 100. I'm confused because my professor told me that it would round up or down to the nearest integer but I'm finding out otherwise on my own since it's always rou

Problem with rounding a number! -
In real life, When we try to round a number, let say 3.825, up to 2 decimal points, the answer is 3.83, right? Unfortunately in VB .NET, the "Math.Round" method & "Decimal.Round" method, round number like this (Read the remarks I quote from the Help file m

Need help with rounding code -
I need to round decimals to the nearest quarter 1.12 would become 1.0 1.13 would become 1.25 7.87 would become 7.75 7.88 would become 8.0 and so on.. Any help is appriciated Thank you Garrett

Rounding to nearest quarter -
Someone posted a thread looking for a way to round a number to the nearest quarter (.25). This thread must have been deleted before I had a chance to respond. Here is how you do it: Code: If (mynumber / 0.25) * 100 Mod 100 Then 'checks to see if number really needs rounding

always rounding up *RESOLVED* -
The Int() function rounds down to the nearest integer. What I want is to round up to the nearest integer. e.g. 10.1 becomes 11 , 9.9 becomes 10 I could do this by using Code: Int(10.4)+1 but was wondering if there is a function that does this for me. The round functio

Rounding time values to the nearest quarter hour -
We need our time-in/time-outs to be rounded to the nearest quarter hour in the timeclock program I'm coding. Basically, I'm using timehold = Now.ToString("HH:mm") right now for the variable I'm inserting into the DB. I need to make it round up/down before I insert it. Let me

Rounding -
How can I convert a double to integer and have it always round down to the nearest integer and not up?

Need a rounding function -
Hi guys, Does anybody know how to create a function which will round up an integer to the nearest multiple of five? I hope this question isn't too stupid, but for some reason I can't figure out how to even get started. Any help is greatly appreciated!

Nearest integer -
Is there a built-in function in VB6 for calculating the "nearest integer" of a non-integer number? For example, Nearest Integer(2.4) = 2 Nearest Integer(2.5) = 3 Nearest Integer(2.8) = 3

Rounding to 1 decimal Place -
Hi, i did a simple division 40/3 and got 13.33333333 for answer. How can i round off the 13.33 to the nearest 1 decimal place so i would get 13.5??

Rounding Decimals -
Hi, is there a decimal round feature in vb6? i want to round a double to its nearest 0.25 value. so it value = 3.28 it would be rounded to 3.5. similarly if the value = 3.82 it would be rounded to 4.00. Thanks

DataGridView truncating values! -
I'm using a bound DataGridView to show some accounting transactions, but even though the database datatype is a decimal(2,0) the datagrid is rounding all my values to the nearest integer!

rounding up (.5) -
Anyone have a very simple solution that rounds up to the nearest .5. For example... x = 1.3 would round up to x = 1.5 x = 1.01 would round up to x = 1.5 x = 1.51 would round up to x = 2 x = 1.99 would round up to x = 2 Thanks for any help...

Rounding Time unit to 15 minutes -
I am currently writing a program that records the number of hours worked on projects to the nearest 15 minutes. i.e 2:25 2:50 2:75 3:00 The most common error that users are making is inputting 2hrs 15mins as 2:15 rather than the required 2:25 Has anyone got a routine that

[2005] Rounding doubles mystery -
Hi all, I am running: Microsoft Visual Studio 2005 Version 8.0.50727.762 (SP.050727-7600) Microsoft .NET Framework Version 2.0.50727 SP1 I have the following code that I am using to round double values. It takes a value to round and a delta value to round to. The delta val

keep from rounding -
I have some formulas outputting to a text box. The numbers keep rounding up. How do I stop this?

Rounding Numbers in VB -
are you rounding or just truncating? your example of 100.956 should round to 100.96 not 100.95 serge's code rounds which is not what your example shows

Help: Rounding problem ! -
Hi, I have an application and that give me rare rounding problem. The statement I use to rounding the value x = x + round((w * y), 2) it loop through 4 records, only two record get rounded corrrectly and the other two is not, I have no idea why. Original value Aft

Stop Rounding -
Good morning, Having a bit of bother at the moment. I've spent the whole morning making a high scores table for my mini games compilation. At the end of each mini game, it asks the user for their name, then writes their name and score to a text file in this format "name, sc

help my numbers are rounding off -
i'm doing a order form, they only problem i am having is my output, all the numbers are rounding off instead of showing decimals, here is my code if someone wants to look at it and tell me what i'm dong wrong, thanks.

Rounding Numbers Within A Textbox -
Hi, Im fairly new to vb.NET, The problem I have is that I want to round a number down instead of it being rounded up. I want to round 10.389 to 10.38 instead of it rounding to 10.39, is this possible? thanks in advance.

C++ automatically rounding off values -
how to resolve the case of c++ rounding off values, for example: cos(6.2832) i get 1 instead of .99999 and 0.1 being only 0... what should i do

stop rounding up -
I have some formulas outputting to a text box. The numbers keep rounding up. How do I stop this?

round to nearest hundred... -
okie dokie, i just need the simplest code/ function / anything to round to the nearest hundred. like if i have 1246 i want 1200 if i have 1256 i want 1300, no big deal, need it for school, but not neccasarrily just those two numbers yaknow ?

Round function Question -
Dear all, I have a question about round function in VB. General Speaking, the round function is quite simple: round(10.123567,3) will return 10.124 which I believe it is using half-adjust rounding method. But right now, I need to have a rounding method function to help me rou

Rounding Problem -
Im using Visual Basic 6 and access 97 When i put a value in the textbox, for exemple 0.5 when writes this value in the database table apears 0. I think its a rounding problem, how can i solve this problem? Thanks in advance!

Getting the nearest prime number -
Can someone give a simple code on how to get the nearest prime number? For example: Key Value: 0...60 Prime Number: 59 (since 59 is the nearest prime number to 60) Note: Prime number < key value

VB function to round to the nearest integer -
hello can you guys tell me what is the VB functio nto round to the nearest integer. the equivalent of c's ceil?

Nearest numbers/multiples -
How would I go about doing this: First, you would need a line. The arrow keys move the X2 and Y2 properties around the form. I want them to move by increments of ten. When I press U, They both move to the nearest multiple of 120. So if X was at 1210 and Y were at 1275, X would equal