Solved

# Rounding in excel

Posted on 2004-09-13
341 Views
I have a number like \$3.894 and need it rounded down to \$3.88
Does anyone know the formula to use?
0
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

LVL 2

Accepted Solution

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

ID: 12049068
0

## Featured Post

Question has a verified solution.

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

### Suggested Solutions

CCNP Exam question 6 36
Cisco Nexus 5 56
Network latency question 9 81
How can we block any website on a server 2007 standard or server 2008R2? 5 50
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.