Thread: MRound Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default MRound Formula

Just use =ROUND(A3*A4,-3) :)

"LauraLee" wrote:

I'm trying to add the Mround to a cell that already has an exisiting formual
(i.e. a3*a4). How do I create the circular reference so that it will round
the figure to the nearest 1,000. Thanks