View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
pshepard[_2_] pshepard[_2_] is offline
external usenet poster
Posts: 55
Default how to multiply two values and round the result

Hi PirateJoe,


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?