Thread: how to multiply two values and round the result
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default how to multiply two values and round the result
Do you mean
=ROUND(A1*B1,2)

If this post helps click Yes
---------------
Jacob Skaria


"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?
Reply With QuoteReply With Quote