Solved

Rounding in excel

Posted on 2004-09-13
2
323 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Forwarding web requests to different web servers 15 82
Restrict RDP Remote Access through SonicWall 3 97
What are acceptable WiFi signal strengths 6 60
nexus filter logs 3 29
Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
I had an issue with InstallShield not being able to use Computer Browser service on Windows Server 2012. Here is the solution I found.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
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…

863 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

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now