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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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?