• Status: Solved
• Priority: Medium
• Security: Public
• Views: 1581

# 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
``````
0
Loganathan Natarajan
• 9
• 3
1 Solution

Technology ScientistCommented:
ciel (round up)
floor (round down)
round (round 4/5)
0

Technology ScientistCommented:
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";

%>
``````
0

Technology ScientistCommented:
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>';
?>
``````
0

Technology ScientistCommented:
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";

?>
``````
0

LAMP DeveloperAuthor Commented:
Hello,

sorry, I want it in Javascript ...
0

Technology ScientistCommented:
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";

?>
``````
0

LAMP DeveloperAuthor Commented:
No, any solution using Javascript...
0

Technology ScientistCommented:
Masterful!

Here is the javascript version of the REPLICATION.

=NerdsOfTech
``````<html>
<title>
Rounding
</title>
<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>
``````
0

Technology ScientistCommented:
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)
``````
0

Technology ScientistCommented:
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
``````
0

Technology ScientistCommented:
Here is the final solution once again. Thank you.
``````<html>
<title>
Rounding
</title>
<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>
``````
0

LAMP DeveloperAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.