Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to round up / round down / round nearest the values?

Posted on 2009-05-13
12
Medium Priority
?
1,556 Views
Last Modified: 2013-12-12
Hi,

How to round up / round down / round nearest the values? Can anyone help to start somewhere ?


If the amount is = 3333.35 then
 
Expected Out Put
-------------------------
 
Round Exact:
---------------------
Round to Exact =   $ 3333.35
Round to $1 =   $ 3333
Round to $10 =   $ 3330
Round to $100 =   $ 3300
Round to $1000 =   $ 3000
 
Round Up
-----------------------
 
Round to Exact =   $ 3333.35
Round to $1 =   $ 3334
Round to $10 =   $ 3340
Round to $100 =   $ 3400
Round to $1000 =   $ 4000
 
 
Round Down
----------------------------------
 
Round to Exact =   $ 3333.35
Round to $1 =   $ 3333
Round to $10 =   $ 3330
Round to $100 =   $ 3300
Round to $1000 =   $ 3000
 
Round nearest
---------------------------
 
Round to Exact =   $ 3333.35
Round to $1 =   $ 3333
Round to $10 =   $ 3330
Round to $100 =   $ 3300
Round to $1000 =   $ 3000

Open in new window

0
Comment
Question by:Loganathan Natarajan
  • 9
  • 3
12 Comments
 
LVL 20

Expert Comment

by:NerdsOfTech
ID: 24381617
ciel (round up)
floor (round down)
round (round 4/5)
0
 
LVL 20

Expert Comment

by:NerdsOfTech
ID: 24381657
Complete replication!
<%php
echp = '<pre>';
echo = "If the amount is = 3333.35 then\n";
$amount = 3333.35;
 
 
echo "Expected Output\n";
echo "-------------------------\n" . "\n" . "\n";
 
echo "\nRound Exact:\n";
echo "---------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound to $1 = \t\$" . round($amount, -1) . "\n";
echo "\nRound to $10 = \t\$" . round($amount, -2) . "\n";
echo "\nRound to $100 = \t\$" . round($amount, -3) . "\n";
echo "\nRound to $1000 = \t\$" . round($amount, -4) . "\n";
 
echo "\nRound Up\n";
echo "-----------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound up $1 = \t\$" . ceil($amount, -1) . "\n";
echo "\nRound up $10 = \t\$" . ceil($amount, -2) . "\n";
echo "\nRound up $100 = \t\$" . ceil($amount, -3) . "\n";
echo "\nRound up $1000 = \t\$" . ceil($amount, -4) . "\n";
 
 
echo "\nRound Down\n";
echo "-------------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound down $1 = \t\$" . floor($amount, -1) . "\n";
echo "\nRound down $10 = \t\$" . floor($amount, -2) . "\n";
echo "\nRound down $100 = \t\$" . floor($amount, -3) . "\n";
echo "\nRound down $1000 = \t\$" . floor($amount, -4) . "\n";
 
echo "\nRound Nearest\n";
echo "-------------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound to $1 = \t\$" . round($amount, -1) . "\n";
echo "\nRound to $10 = \t\$" . round($amount, -2) . "\n";
echo "\nRound to $100 = \t\$" . round($amount, -3) . "\n";
echo "\nRound to $1000 = \t\$" . round($amount, -4) . "\n";
 
%>

Open in new window

0
 
LVL 20

Expert Comment

by:NerdsOfTech
ID: 24381669
DOh! PHP tags.. FIXED!
<?php
echo = '<pre>';
echo = "If the amount is = 3333.35 then\n";
$amount = 3333.35;
 
 
echo "Expected Output\n";
echo "-------------------------\n" . "\n" . "\n";
 
echo "\nRound Exact:\n";
echo "---------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound to $1 = \t\$" . round($amount, -1) . "\n";
echo "\nRound to $10 = \t\$" . round($amount, -2) . "\n";
echo "\nRound to $100 = \t\$" . round($amount, -3) . "\n";
echo "\nRound to $1000 = \t\$" . round($amount, -4) . "\n";
 
echo "\nRound Up\n";
echo "-----------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound up $1 = \t\$" . ceil($amount, -1) . "\n";
echo "\nRound up $10 = \t\$" . ceil($amount, -2) . "\n";
echo "\nRound up $100 = \t\$" . ceil($amount, -3) . "\n";
echo "\nRound up $1000 = \t\$" . ceil($amount, -4) . "\n";
 
 
echo "\nRound Down\n";
echo "-------------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound down $1 = \t\$" . floor($amount, -1) . "\n";
echo "\nRound down $10 = \t\$" . floor($amount, -2) . "\n";
echo "\nRound down $100 = \t\$" . floor($amount, -3) . "\n";
echo "\nRound down $1000 = \t\$" . floor($amount, -4) . "\n";
 
echo "\nRound Nearest\n";
echo "-------------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound to $1 = \t\$" . round($amount, -1) . "\n";
echo "\nRound to $10 = \t\$" . round($amount, -2) . "\n";
echo "\nRound to $100 = \t\$" . round($amount, -3) . "\n";
echo "\nRound to $1000 = \t\$" . round($amount, -4) . "\n";
echo '</pre>';
?>

Open in new window

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 20

Expert Comment

by:NerdsOfTech
ID: 24381672
Doh! syntax fixed. Rounding precision fixed.

USE THIS CODE. NOT THE ABOVE!

<?php
echo '<pre>';
echo "If the amount is = 3333.35 then\n";
$amount = 3333.35;
 
 
echo "Expected Output\n";
echo "-------------------------\n" . "\n" . "\n";
 
echo "\nRound Exact:\n";
echo "---------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound to $1 = \t\$" . round($amount, 0) . "\n";
echo "\nRound to $10 = \t\$" . round($amount, -1) . "\n";
echo "\nRound to $100 = \t\$" . round($amount, -2) . "\n";
echo "\nRound to $1000 = \t\$" . round($amount, -3) . "\n";
 
echo "\nRound Up\n";
echo "-----------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound up $1 = \t\$" . ceil($amount, 0) . "\n";
echo "\nRound up $10 = \t\$" . ceil($amount, -1) . "\n";
echo "\nRound up $100 = \t\$" . ceil($amount, -2) . "\n";
echo "\nRound up $1000 = \t\$" . ceil($amount, -3) . "\n";
 
 
echo "\nRound Down\n";
echo "-------------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound down $1 = \t\$" . floor($amount, 0) . "\n";
echo "\nRound down $10 = \t\$" . floor($amount, -1) . "\n";
echo "\nRound down $100 = \t\$" . floor($amount, -2) . "\n";
echo "\nRound down $1000 = \t\$" . floor($amount, -3) . "\n";
 
echo "\nRound Nearest\n";
echo "-------------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound to $1 = \t\$" . round($amount, 0) . "\n";
echo "\nRound to $10 = \t\$" . round($amount, -1) . "\n";
echo "\nRound to $100 = \t\$" . round($amount, -2) . "\n";
echo "\nRound to $1000 = \t\$" . round($amount, -3) . "\n";
 
?>

Open in new window

0
 
LVL 36

Author Comment

by:Loganathan Natarajan
ID: 24381673
Hello,

sorry, I want it in Javascript ...
0
 
LVL 20

Expert Comment

by:NerdsOfTech
ID: 24381732
Oh LOL sorry I was doing it in PHP.
Here is the correct PHP code. BRB with the javascript solution!
<?php
echo '<pre>';
echo "If the amount is = 3333.35 then\n";
$amount = 3333.35;
 
 
echo "Expected Output\n";
echo "-------------------------\n" . "\n" . "\n";
 
echo "\nRound Exact:\n";
echo "---------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound to $1 = \t\t\$" . round($amount, 0) . "\n";
echo "\nRound to $10 = \t\t\$" . round($amount, -1) . "\n";
echo "\nRound to $100 = \t\$" . round($amount, -2) . "\n";
echo "\nRound to $1000 = \t\$" . round($amount, -3) . "\n";
 
echo "\n\n\nRound Up\n";
echo "-----------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
 
// 3333.35
// 3333.3
// 3340.0
//  33.33
 
 
echo "\nRound up \$1 = \t\t\$" . ceil(round($amount, 2)) . "\n";
echo "\nRound up \$10 = \t\t\$" . ceil(round($amount)/10)*10 . "\n";
echo "\nRound up \$100 = \t\$" . ceil(round($amount)/100)*100 . "\n";
echo "\nRound up \$1000 = \t\$" . ceil(round($amount)/1000)*1000 . "\n";
 
 
echo "\n\n\nRound Down\n";
echo "-------------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound down \$1 = \t\$" . floor(round($amount)/1)*1 . "\n";
echo "\nRound down \$10 = \t\$" . floor(round($amount)/100)*100 . "\n";
echo "\nRound down \$100 = \t\$" . floor(round($amount)/100)*100 . "\n";
echo "\nRound down \$1000 = \t\$" . floor(round($amount)/1000)*1000 . "\n";
 
echo "\n\n\nRound Nearest\n";
echo "-------------------------\n" . "\n";
 
echo "\nRound to Exact = \t\$" . round($amount, 2) . "\n";
echo "\nRound to \$1 = \t\t\$" . round($amount, 0) . "\n";
echo "\nRound to \$10 = \t\t\$" . round($amount, -1) . "\n";
echo "\nRound to \$100 = \t\$" . round($amount, -2) . "\n";
echo "\nRound to \$1000 = \t\$" . round($amount, -3) . "\n";
 
?>

Open in new window

0
 
LVL 36

Author Comment

by:Loganathan Natarajan
ID: 24381767
No, any solution using Javascript...
0
 
LVL 20

Expert Comment

by:NerdsOfTech
ID: 24381816
Masterful!

Here is the javascript version of the REPLICATION.

=NerdsOfTech
<html>
<head>
<title>
Rounding
</title>
</head>
<body>
<pre>
<script language="Javascript">
document.write ("If the amount is = 3333.35 then\n\n");
amount = 3333.35;
 
document.write ("Expected Output\n");
document.write ("-------------------------\n" + "\n");
 
document.write ("\nRound Exact:\n");
document.write ("---------------------\n" + "\n");
 
document.write ("\nRound to Exact = \t\$" + Math.round(amount*100)/100 + "\n");
document.write ("\nRound to $1 = \t\t\$" + Math.round(amount) + "\n");
document.write ("\nRound to $10 = \t\t\$" + Math.round(amount/10)*10 + "\n");
document.write ("\nRound to $100 = \t\$" + Math.round(amount/100)*100 + "\n");
document.write ("\nRound to $1000 = \t\$" + Math.round(amount/1000)*1000 + "\n");
 
 
document.write ("\n\n\nRound Up\n");
document.write ("-----------------------\n" + "\n");
 
document.write ("\nRound to Exact = \t\$" + Math.round(amount*100)/100 + "\n");
document.write ("\nRound up \$1 = \t\t\$" + Math.ceil(amount) + "\n");
document.write ("\nRound up \$10 = \t\t\$" + Math.ceil(Math.round(amount)/10)*10 + "\n");
document.write ("\nRound up \$100 = \t\$" + Math.ceil(Math.round(amount)/100)*100 + "\n");
document.write ("\nRound up \$1000 = \t\$" + Math.ceil(Math.round(amount)/1000)*1000 + "\n");
 
 
document.write ("\n\n\nRound Down\n");
document.write ("-------------------------\n" + "\n");
 
document.write ("\nRound to Exact = \t\$" + Math.round(amount*100)/100 + "\n");
document.write ("\nRound down \$1 = \t\$" + Math.floor(amount) + "\n");
document.write ("\nRound down \$10 = \t\$" + Math.floor(Math.round(amount)/10)*10 + "\n");
document.write ("\nRound down \$100 = \t\$" + Math.floor(Math.round(amount)/100)*100 + "\n");
document.write ("\nRound down \$1000 = \t\$" + Math.floor(Math.round(amount)/1000)*1000 + "\n");
 
document.write ("\n\n\nRound Nearest\n");
document.write ("-------------------------\n" + "\n");
 
document.write ("\nRound to Exact = \t\$" + Math.round(amount*100)/100 + "\n");
document.write ("\nRound to \$1 = \t\t\$" + Math.round(amount) + "\n");
document.write ("\nRound to \$10 = \t\t\$" + Math.round(amount/10)*10 + "\n");
document.write ("\nRound to \$100 = \t\$" + Math.round(amount/100)*100 + "\n");
document.write ("\nRound to \$1000 = \t\$" + Math.round(amount/1000)*1000 + "\n");
 
</script>
<br />
</pre>
 
</body>
</html>

Open in new window

0
 
LVL 20

Expert Comment

by:NerdsOfTech
ID: 24381828
In your case you will need to reference

Math.round (5/4 rounding)
if tenth unit is 4 or lower round down, if tenth unit is 5 or higher round up
http://www.w3schools.com/jsref/jsref_round.asp

Math.ceil (round up)
if fraction exist round up to nearest integer
http://www.w3schools.com/jsref/jsref_ceil.asp

Math.floor (round down)
if fraction exist round down to nearest integer
http://www.w3schools.com/jsref/jsref_floor.asp

// Math.round (round)
// Math.ceil (up)
// Math.floor (down)

Open in new window

0
 
LVL 20

Expert Comment

by:NerdsOfTech
ID: 24381855
Also notice the pattern
document.write ("\nRound to $10 = \t\t\$" + Math.round(amount/10)*10 + "\n");
since we are rounding to the nearest 10.00
we need to divide by 10.00
round
then multiply by 10

The same pattern exist for all lines:
document.write ("\nRound to Exact = \t\$" + Math.round(amount*100)/100 + "\n");
since we are rounding to the nearest .01
we need to divide by 0.01 (or multiply by 100 in algebraical terms)
round
then multiply by 0.01 (or divide by 100 in algebraical terms)

Therefore, for complete uniform pattern sake you could have written this instead:
document.write ("\nRound to Exact = \t\$" + Math.round(amount/0.01)*0.01 + "\n");
since it is the same as
document.write ("\nRound to Exact = \t\$" + Math.round(amount*100)/100 + "\n");

Thus,
the formula is:
Math.Round(amount / precision) * precision
So if you wanted 123456789 to the nearest 100,000.
amount=123456789;
precision=100000;
document.write (Math.round(amount / precision)*precision);
//output is 123500000

Open in new window

0
 
LVL 20

Accepted Solution

by:
NerdsOfTech earned 2000 total points
ID: 24381865
Here is the final solution once again. Thank you.
<html>
<head>
<title>
Rounding
</title>
</head>
<body>
<pre>
<script language="Javascript">
document.write ("If the amount is = 3333.35 then\n\n");
amount = 3333.35;
 
document.write ("Expected Output\n");
document.write ("-------------------------\n" + "\n");
 
document.write ("\nRound Exact:\n");
document.write ("---------------------\n" + "\n");
 
document.write ("\nRound to Exact = \t\$" + Math.round(amount*100)/100 + "\n");
document.write ("\nRound to $1 = \t\t\$" + Math.round(amount) + "\n");
document.write ("\nRound to $10 = \t\t\$" + Math.round(amount/10)*10 + "\n");
document.write ("\nRound to $100 = \t\$" + Math.round(amount/100)*100 + "\n");
document.write ("\nRound to $1000 = \t\$" + Math.round(amount/1000)*1000 + "\n");
 
 
document.write ("\n\n\nRound Up\n");
document.write ("-----------------------\n" + "\n");
 
document.write ("\nRound to Exact = \t\$" + Math.round(amount*100)/100 + "\n");
document.write ("\nRound up \$1 = \t\t\$" + Math.ceil(amount) + "\n");
document.write ("\nRound up \$10 = \t\t\$" + Math.ceil(Math.round(amount)/10)*10 + "\n");
document.write ("\nRound up \$100 = \t\$" + Math.ceil(Math.round(amount)/100)*100 + "\n");
document.write ("\nRound up \$1000 = \t\$" + Math.ceil(Math.round(amount)/1000)*1000 + "\n");
 
 
document.write ("\n\n\nRound Down\n");
document.write ("-------------------------\n" + "\n");
 
document.write ("\nRound to Exact = \t\$" + Math.round(amount*100)/100 + "\n");
document.write ("\nRound down \$1 = \t\$" + Math.floor(amount) + "\n");
document.write ("\nRound down \$10 = \t\$" + Math.floor(Math.round(amount)/10)*10 + "\n");
document.write ("\nRound down \$100 = \t\$" + Math.floor(Math.round(amount)/100)*100 + "\n");
document.write ("\nRound down \$1000 = \t\$" + Math.floor(Math.round(amount)/1000)*1000 + "\n");
 
document.write ("\n\n\nRound Nearest\n");
document.write ("-------------------------\n" + "\n");
 
document.write ("\nRound to Exact = \t\$" + Math.round(amount*100)/100 + "\n");
document.write ("\nRound to \$1 = \t\t\$" + Math.round(amount) + "\n");
document.write ("\nRound to \$10 = \t\t\$" + Math.round(amount/10)*10 + "\n");
document.write ("\nRound to \$100 = \t\$" + Math.round(amount/100)*100 + "\n");
document.write ("\nRound to \$1000 = \t\$" + Math.round(amount/1000)*1000 + "\n");
 
</script>
<br />
</pre>
 
</body>
</html>

Open in new window

0
 
LVL 36

Author Closing Comment

by:Loganathan Natarajan
ID: 31581307
thank you
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
Suggested Courses

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question