<div>
<div class="content wysiwyg-content">
Folks,<br />
<br />
I have a column that contains a calculated result, e.g <br />
<br />
Field_1 = $50, Field_2 = $2.7122 &amp;&nbsp;Field_3 = $135.61<br />
<br />
Field_1 * Field_2 = Field_3<br />
<br />
Now I want to have a new field where I have Field_3 rounding off to $140.00 so that i have an even number..
</div>
</div>


Folks,

I have a column that contains a calculated result, e.g 

Field_1 = $50, Field_2 = $2.7122 & Field_3 = $135.61

Field_1 * Field_2 = Field_3

Now I want to have a new field where I have Field_3 rounding off to $140.00 so that i have an even number..

Formulae for rounding off numbers

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