[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2009-05-13
12
Medium Priority
?
1,535 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 3
12 Comments
 
LVL 19

Expert Comment

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

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 19

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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 19

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 19

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 19

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 19

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 19

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 19

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

Technology Partners: 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!

Question has a verified solution.

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

Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses

656 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