how to multiply two values and round the result
Hi PirateJoe,
=round(formula)
then format the cell to display as currency.
--
If this post helps click Yes
---------------
Peggy Shepard
"PirateJoe" wrote:
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?
|