<div>
Use this assuming you got value in A1..then formula in b1 will be...<br />
<br />
=round(a1,2)<br />
<br />
This will round it two decimal places...<br />
<br />
Saurabh....
</div>


Use this assuming you got value in A1..then formula in b1 will be...

=round(a1,2)

This will round it two decimal places...

Saurabh....

<div>
but there is a problem with that rounding as you can see 77.001 is rounding to 77 but it should round to 77.01 also i tried 76.85483 this rounded to 76.85 but I want to see to the next penny which is 76.86
</div>


but there is a problem with that rounding as you can see 77.001 is rounding to 77 but it should round to 77.01 also i tried 76.85483 this rounded to 76.85 but I want to see to the next penny which is 76.86

<div>
Only rounding will not give you the output you are expecting. You will need to try it like this....<br />
Assuming your number is in A1 then...<br />

<pre><code id="code-20-41388614-1">=ROUND(A1,2)+0.01</code></pre>
</div>


Only rounding will not give you the output you are expecting. You will need to try it like this....
Assuming your number is in A1 then...


=ROUND(A1,2)+0.01

<div>
Or rather use Roundup like this.....<br />
<br />

<pre><code id="code-20-41388625-1">=ROUNDUP(A1,2)</code></pre>
</div>


Or rather use Roundup like this.....



=ROUNDUP(A1,2)

<div>
@Saurabh<br />
You were pretty fast on this. :)
</div>


@Saurabh
You were pretty fast on this. :)

<div>
@Sktneer,<br />
<br />
I need to..I know talented experts like you are here..and if i need to beat you to it..i need to be fast.. :-)<br />
<br />
Saurabh...
</div>


@Sktneer,

I need to..I know talented experts like you are here..and if i need to beat you to it..i need to be fast.. :-)

Saurabh...

<div>
lol. For me it's time to logoff now. See you in another thread. :)
</div>


lol. For me it's time to logoff now. See you in another thread. :)

<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 500 points for saurabh726's comment <a href="https://www.experts-exchange.com/questions/28906655/Excel-formula-Question-Rounding.html?anchorAnswerId=41388619#a41388619" rel="ugc">#a41388619</a><br />
<br />
for the following reason:<br />
<br />
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


I've requested that this question be closed as follows:

Accepted answer: 500 points for saurabh726's comment #a41388619 [https://www.experts-exchange.com/questions/28906655/Excel-formula-Question-Rounding.html?anchorAnswerId=41388619#a41388619]

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
I have a requirement in my excel sheet that if the cell value is like 128.0304, I have to round it to 128.04, another example 77.001 to 77.01, another example 76.85483 to 76.86.IS this doable in excel formula.
</div>
</div>


I have a requirement in my excel sheet that if the cell value is like 128.0304, I have to round it to 128.04, another example 77.001 to 77.01, another example 76.85483 to 76.86.IS this doable in excel formula.

Excel formula Question-Rounding

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.