Math.round
How can I round the value to the nearest whole number. I have searched on math.round but
can not get it to function. Here is how I am getting the results if not division by zero. Code:
ADVERTISEMENT
Math Functions...
Didn't remember if anybody had started started like this, but I decided it would be cool to start it again. If you have a math function request ask it below, or if you have made one then add it:
I have a few cretegean plane (think thats how you spell it), calculations. One request I have is, does anybody have a short function for square root?
Math Question
i need to print the x value of a circle (center is 0 and max = 1)
depending on the angle entered
i know it is possible with functions but i dont remember wich one
example :
user enter 0 : returned value is 0
user enter 45 : returned value is 0.5
user enter 90: returned value is 1
user enter 135 the returned value is 0.5
user enter 180 the returned value is 0
user enter 225 the returned value is -0.5
...
and so on
Simple Math
I am trying to add my numeric fields together to produce a total. Does the following make sense to anyone? Code:
View Replies View RelatedDoing A Math Problem With ASP
I want to enter a math formula to caculate how many pages are there for each thread.
At this point, I set the page break to 15 posts for each thread. In other words, one page contains 15 replies to one thread. If there are more than 15 and less than 30 replies, then page number is equal to 2. If more than 30, the page number is equal to 3.
If I translate this to a math formula, it would be like
total replies divided by 15 = the number of page (this number should round up like 0.x=1)
if total replies is 3, so 3 divided by 15 = 0.2 (round it up to 1)
if total replies is 18, so 18 divided by 15 = 1.2 (round it up to 2)
How can I do this?
Math Working
<%
Dim BeforeTax
Dim A
Dim B
Dim C
A = OrderSummary.Fields.Item("Order_Total").Value
B = OrderSummary.Fields.Item("Tax").Value
C = OrderSummary.Fields.Item("Shipping").Value
BeforeTax = A-(B+C)
%>
I tried this after I tried to have just one line with BeforeTax = OrderSummary.Fields.Item("Order_Total").Value-....
Any idea why I get an error?
Math Equation
normally if i want to do a simple math equation and user only key in A and B but the C will be auto generate. and i wanna store all these three variables in the system. can anyone write a simple program for me? i declare inside head tag rite?
View Replies View RelatedMath Behind The Sessionid
how unique the sessionid is in ASP. What is the math behind it's creation, and what are the probobolities of it being reproduced, i.e. 1/10000? or 1 in twenty million? Can someone give me some guidance on this? I'm trying to create some unique numbers for
data assignement, and would like a way that does not replicate.
Simple Math In Asp
i am trying to remove stock from my database when someone orders a product. basically the code has no errors but it wont change the stock level.
how do i get asp to subtract one number from another the bit of code i have for this part of the function is Code:
Math Calculations
I have a page which has a buyers premium amount field and an empty field the client will place the amount they wish to bid.
How can I get the page to calculate the premium total and the grand total. will I need to put some sort of button on the page to request the calculation or can it be triggered automatically?
Math Calculator
I just developed a simple math calculator using c# in asp.net, now i want to be able to check for the higest and lowest answer from the label control, how to do this?
View Replies View RelatedMath Functions In Forms
I have several forms written in asp and I would like to make a couple of the fields autocaculate, but I have no clue how to go about this. I only need addition and division.
View Replies View RelatedROUND Up
I have the following equation.
<% varWT = Round(CInt((rsFreePack.Fields.Item("Weight").Value)) +
CInt(Session("w"))) %>
Assume....
Round(CInt((rsFreePack.Fields.Item("Weight").Value)) = .12
CInt(Session("w")) = 30
How can I get it to always ROUND up to 31 ...?
Round Up
I have a number with a decimal point that i always want to round upwards to the nearest whole number.Now i can use the round(No.) function and this works for any value of .5 and above the problem is the lower .1 .2 .3 .4.So an example
if i get the number 14.2 i want the output to be 15
11.3 = 12
13.8 = 14
Round Up
If I have a value that is 53.123499999, how can I round it to 53.12?
View Replies View RelatedRound A Variable
I have a variable (ex. 5.66666666) and I want to round it to 2 decimal places. Anyone got this code?
View Replies View RelatedHow To Round Up A Whole Number?
I've created a freight calculator that needs to know how many pallets I'm shipping. I'm using 1 pallet for 750lbs and an extra pallet for anything more than that.
If materialWeight <= 750 Then numPallets = 1 Else numPallets = Round(materialWeight / 750) End If
Now, let's say the materialWeight/750 ends up being 3.2. This is returning 3, but I need it to return 4 since we need an extra pallet.
How can I make it Round up to the next whole number? If it turned out to be an exact number without a decimal then it should stay where it is, but if it's over x.0 at all it should go up to the next whole number.
Round() Vs FormatNumber()
I'm working on finishing a project the was started by someone else who no longer works here. Its an asp page that takes a whack of numbers form a db, and makes em look all pretty in tables. (its a remake of an excel spreadsheet)
the problem is some of the numbers are not apearing properly. I'm thinking it's because they used Round() sometimes and formatNumber() other times.
the question is... do these functions handle numbers differently? i know formatNumber can do more then just round but i just need it to make the numbers 1 or 2 decimals.
Round Numbers To 0
I want to round numbers to include a 0 at the end.
response.write "<td bgcolor=white align=center class=menuText>" & 100 - Round(CTASCAvail,2) & "%</td>"
response.write "<td bgcolor=white align=center class=menuText>" & 100 - Round(Avail,2) & "%</td>"
the following code will round the numbers 2 decimal places but if it is a 0 it will not display it.
Round Time
Does anyone know how I could round the minutes to the nearest 15 minutes, I'm using this
%=minute(now()) %>
Round Up Number
Given: total = 18.01
I use FormatNumber(total,2), it give me 18.01
I use FormatNumber(total,0) it give me 18
I wanna to get 19, how should i do the code?? if there is any decimal
value, i wanna round it up to the next whole number.
Round A Number Up
I am dividing a value by two .. what i need is to round the number up if it is not a whole number.
View Replies View RelatedRound() :: Rounding Bug
i have a very simple question which is driving me nuts. Using the ASP function Round():
Why do BOTH Round(1.775, 2) and Round(1.785, 2) both give the exact same result of 1.78 ?
Surely they should give different results, 1.78 and 1.79 respectively.
Round Up A Figure
for eg x = 3.14. I want to do a round up to 1 decimal. if I were to use round(3.14) , I will get 3.1 , however I want to round up , expecting to get 3.2 .
View Replies View RelatedRound Upwards
In ASP, how do I do this?
Like 1.5 ---> 2
1.001 ---> 2
4.3---> 5
5.0001---> 6
Round Numbers
how to round off numbers i have tried 2 different ways but hitting the dead end. say for example the number stored in my variable is
strnum="112"
i want to round it to 115 so my new value will be strnum="115" . so if its 113 it should be rounded to 115 . if its 116 or 117 or 118 or 119 it should be 120 . if its 111 or 112 or 113 it should be 115 . how i can round the numbers.
Round Function
If I have a number that looks like 32.3, 15.5, 30.1 etc, I always assumed Price = Round(Price,2) is actually rounding a figure into a whole number or putting 32.30 etc.
So how do you exactly round the figure to whole number or put a zero at the end of it. I was thinking of formatNumber but I can't remember if there is a function for that?
Next Round In Loop
I looped a record set to display and I found a strnage thing. as
Do While NOT rsBinAct.EOF
l_bin = rsBinAct.Fields("o_bin")
l_niin = rsBinAct.Fields("o_bin_niin")
l_b = LEFT(l_niin, 3)
l_n = RIGHT(l_niin, LEN(l_niin)-3 )
' display l_bin, l_b, l_n in a table-like page
rsBinAct.MoveNext
Loop
If I do not set the l_b and l_n to NULL then if the next l_niin is null value, I will get the l_n value of previous one only, l_b is still null. I wonder why.
ROUND .. How Do I Format These Numbers Right?
I'm using the following:
priceDelivered = Round(((totalMaterialPrice + rateWithHandling) / sqFtAmt),2)
It works great except for when it ends in 0, like $4.80. It only prints $4.8.
How can I make sure that even when these numbers end in 0 it shows 2 decimal places?
Display Round Numbers
i am stuck on rounding i have a variable which holds a number like this
a=234.56789
and i want to display only
234
so i did like this
a=Formatnumber(a)
and output is
234.56
but i only need 234
Round Function Alternative
Good:
246/10 = 24.6
round(24.6) = 25
Bad:
246/100 = 2.46
round(2.46) = 2 (I want 3)
If I have a decimal, I want to round up. Always. How do I achieve this in ASP?
Invalid Use Of Null: 'round'
cart_calc_shipping_cost = (Rs.Fields("InitialCost")+(round((Weight/1000)+0.5)-1) * Rs.Fields("AdditionalCost"))
Seems to give me this error:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'round'
I think it is to do with the value of weight, however weight does have to be sometimes 0 so how can i fix this?
Loop Round All Querystring Parameters?
Is it possible to loop round all querystring parameters in a web page (i.e. access them without hardcoding them)?
I want to do this because I have a page that has different querystring variables passed into it depending on the content of the calling page.