View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
Posts: 3,346
Default how to multiply two values and round the result


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.

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?