Solved

Rounding in excel

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
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.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Suggested Courses

695 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