Rounding Up Whole Numbers?
Feb 15, 2012I have a number like 6511 and I want to round it up to 7000. How do I tell the computer to round the numbers to the thousands place. I know how to round decimals but not whole numbers.
View 8 RepliesI have a number like 6511 and I want to round it up to 7000. How do I tell the computer to round the numbers to the thousands place. I know how to round decimals but not whole numbers.
View 8 RepliesLets say my number in text box is 0.376 (3 numbers after decimal) how to round it in a same text box to 0.38 (2 numbers after decimal). Basically any number to x.xx form . Can I have a code for that please
View 4 Replieshow to avoid rounding off numbers
Code below
Dim acc = 0
Dim i
Dim x() = {699.68, 632.70}
[Code].....
I'm a college student, working on a small project, and I'm having some trouble understanding the Round command on VB. The project is very simple and straight forward, just a simple Bail Bonds program to calculate the bail plus a 10% fee. However, i want to integrate a kind of "promotion", where for every $1000 of the bail cost, $5 would be deducted. I know the formula for this, which is reasonable simple, i just need to know how to round the Bail variable to the nearest 1000 so i can do this calculation.
View 9 RepliesPrivate Sub calc2_Click()
Dim t As Long
Dim V As Long
Dim w As Long
[code]....
I haven't used VBA in a very very long time. So, go easy on me. I'm trying to do an IF THEN ELSE function where whatever the pVal cell says, Excel will input the correct currency value in the next cell. I have the cell format in the Excel workbook set to currency with 2 decimal places. However, when I add the UDF, it rounds up! I basically copied and pasted this code from an online website, but theirs did not have any decimals. I've tried calcvalue = Format("48.95","Currency") but it still rounds. I'm sure I'm leaving out something simple. Here's my function formula so far.
[Code]...
I have a series of text boxes with numbers. They are an array called txtBF(0 to 16). I am trying to take the value that is to be displayed in the text box and make it have only one decimal place. I have tried using this code below but I keep getting an error message Run Time Error 13: Type Mismatch.
txtBF(11).text = Round(txtBF(11).text, 1)
and I have also tried this
txtBF(11).text = Math.Round(txtBF(11).text, 1)
i know this may soiund a bit of a n00bish question or 1 that pops out every now and then, but i am havin trouble trying to round off nubers.basically i ahev this label where a value i s inputted by the system after it goes thruogh user inputting so:1)user inputs somehting (* by somethingh)2) user input (* by something )etc etc.val(label1.text) = the additon of all those user inputs---to make life easier lets ust say user input1 = user input 2 k sometimes the val of label1 becomes a decimal point like 3453453.666777 etc when this happens i just want to round up to 2 decimal places i have looked on msdn for help which gave me:
[Code]..
How would I go about rounding up decimal numbers to the nearest 2 decimal places? For example $7.0000032 would be $7.01 In theory, VB would make it $7.00 but if it is > $7.00, I want it to reflect that to the nearest penny... so $3.0000001 would be $3.01
View 5 Repliesif i have an integer a_variable = 1.1 how do i round it up to 2?
View 2 RepliesI have very basic question, I'm really not familiar with vb.net.
I have code like this: Dim minutes As Integer = (55 / 60)
I want this to return 0 to me, integer 0 (no decimals), but vb.net rounds this to 1.
Can someone hint me up how to accomplish this ?
edit. OK for those with same problem try dividing with (Yeah, it's not escape character in vb.net)
How can I round 4.39 to 5 in VB.NET? I tried:
Math.Round(4.39, 0)
But it displays 4.
i'm new to this forum and my doubt is i'm having three text box and say for eg.textbox1.text,textbox2.text,textbox3.text. and we are giving 4.52 and 8.76 as input in textbox 1 and 2 respectively the actual output we obtain is 39.5952, but i should get it as 39.59(only two digits after decimal point and no rounding) in textbox3
View 1 RepliesHow can I round a percentage off to the nearest whole number? [code]
View 5 RepliesI need code that would take the input from textbox "Txtkbb" and divide it in half then round to the nearest 25 and store it in value "KbbValue"
View 4 Replieswhat is the syntax to round up a decimal leaving 2 digits after the decimal point,
ex: 2.566666 -> 2.57
I have a group of 25 labels named Label1, Label2, Label3, ... Label25 in a square of 5 per row, 5 per column and I wanted to assign the backcolor to all of them on a loop and assign a value of "True" or "False" to a matrix of 25 boolean values representing them.
But I was getting errors on the pattern created.
My approach was to use a substring containing a number copied from the label names:
Num = Val(sender.name.substring(5))
And the subindexes of the matrix:
p = (Num - 1) / 5
q = (Num - 1) Mod 5
The values for the lower corner of the matrix were rouded to 5 instead of being 4. Instead of (4,0) ,(4,1), (4,2), (4,3) (4,4) I was getting (5,0),(5,1)...(5,5)
So I solved the problem by creating two single variables "A" and "B", doing the divission and MOD operations on them, finding the floor of them and then converting to integer:
Private Sub Label1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles _
Label1.Click, Label2.Click, Label3.Click, Label4.Click, Label5.Click, _
[Code]......
i have the number 2.523 and its changing to 23. how can i cancel it?
View 1 RepliesI need a function that takes a decimal, with a certain number of digits behiond the comma and convert it to a string with a different number of n digits behind the comma. (to display it)My problem is the rounding ip/down.
like 123,789 with n = 2 --> 123,79
or 123,4 with n = 0 --> 123
or 123,5 with n = 0 --> 124
I did not find an existing function that does that, so I wrote one myself.However the code has become soo complex and it still does not work well, and I get frustrated to spend soo much time with something so trivial.Does anyone know a function that can do this? There must be something out there.
What is the rounding method that VB.NET uses when a double is used in a for statement like this. It looks like 5.5 is rounded to 6 and 10.5 is rounded to 10. The output of the program is 6 7 8 9 10
Sub Main()
Dim A As Double
Dim B As Double
[code]....
I'm using .Net 3.51 SP1. I've been having problems with .Net's inability to add single numbers, could anyone throw some light on this.
[Code]...
I've been trying get rid of decimals on a number, but I need the whole number, so I can't have it rounded. I've tried .ToString and Format(), but without any luck.
View 3 RepliesI'm using the following code to show the percentage of correctly answered questions
Percentage.Text = rightAnswers / 60 * 100 & "%" There are 60 questions and if the user answers 8 correctly the above code shows the answer as 13.33333333..%
How can i round it off to just whole numbers e.g. 13%?
Im working on a program that is about to drive me nuts figuring out how to round and show only 3 or 4 numbers past the decimal placement and also show the scientific notation.
Here is an example of the code.[code...]
The problem here is that most of these calulations turn up so long that my text boxes just show a small portion of the answer. I have really investigated rounding and decimal placement but nothing seems to work...does anyone have a solution?
I need to round a single variable up to the nearest integer no matter what the decimal points are, weather it be 74.1 or 74.4 I always need it to round up to 75.ere is a sample of the code i am using
'Varibles
Dim sngLength As Single
Dim sngWidth As Single
[code]....
is it possible to make the edges on a form rounded rather than a sharp edge?
View 2 RepliesI am trying to make a *simple* calculator. I have everything I need but I want it to always round up if there is a decimal to the nearest whole number.
View 2 RepliesI have a bit of code that returns some stupidly long number, and i need it to round up or down to 2 decimal places. I've looked online but I dont really understand much of it (I'm still learning!).
Code:
shill = txtshill.Text * 5
pen = txtpen.Text / 2.5
[code].....
So I have to take a table and convert it to a text box after I take 10% off the listed price, round up, and then subtract .01 and then compare the two values and display the cheapest.I am hitting a roadblock on how to round up for one.[code]
View 3 RepliesHow do I go about rounding up to the nearest (Unit 10) ie Codes Below
IfVal(TimeHalfFareTextBox.Text = $/£ 0.05)
Then roundup
to $/£ 0.10. Or it might be .....
[Code]....