Solved

Rounding in excel

Posted on 2004-09-13
2
335 Views
Last Modified: 2010-04-11
I have a number like $3.894 and need it rounded down to $3.88
Does anyone know the formula to use?
0
Comment
Question by:steveLaMi
2 Comments
 
LVL 2

Accepted Solution

by:
yavooza earned 500 total points
ID: 12048798
yes here it is:

3.894 can be rounded up to 3.89 only .

but if you want it to be rounded to 3.88 you have to substract the rounded value 3.89 by 0.01 .

I will show both preocedures:

if your value i.e. 3.894 is in cell B3 and you want your answer in cell b4 type this cell b4:

=ROUND(B3,2) and press enter the value 3.89 will be entered to the cell b4.

if you want the value 3.88;

type   =ROUND(B3,2)-0.01  in cell b4 and press enter. you will get 3.88 but this is not the correct rounded answer as 3.89 is the correct answer

pls provide Feedback
0
 

Author Comment

by:steveLaMi
ID: 12049068
Excellent point about the incorrect answer.  Your answer worked great.. Thank You.
0

Featured Post

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

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

Suggested Solutions

Let’s list some of the technologies that enable smooth teleworking. 
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

820 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