how to multiply two values and round the result

[PirateJoe]

I have a result of a function that multiplies two cells (currency and a
percent) that I would like rounded to the nearest dollar. Where do I tell
excel to round the result?

 

[Peo Sjoblom]

=ROUND(your_formula,0)

--


Regards,


Peo Sjoblom

 

[Jacob Skaria]

Do you mean
=ROUND(A1*B1,2)

If this post helps click Yes

 

[pshepard]

Hi PirateJoe,

=round(formula)

then format the cell to display as currency.

 

[T. Valko]

Try this:

=ROUND(A2*B2,0)

 

[Shane Devenshire]

Hi,

You can round the actual value using ROUND(A1,0)

Or you can round the display by choosing Format, Cells, Number tab,
currency, 0 decimal places.