asked on

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

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

NerdsOfTech

ciel (round up)
floor (round down)
round (round 4/5)

NerdsOfTech

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

NerdsOfTech

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

NerdsOfTech

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

Loganathan Natarajan

ASKER

Hello,

sorry, I want it in Javascript ...

NerdsOfTech

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

Loganathan Natarajan

ASKER

No, any solution using Javascript...

NerdsOfTech

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

NerdsOfTech

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

NerdsOfTech

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

ASKER CERTIFIED SOLUTION

NerdsOfTech

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Loganathan Natarajan

ASKER

thank you