View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default Inserting MROUND into existing data

Hi Mac,

Really need a lot more information here.
How? Why? What are you trying to do etc?
As well as some example data.
It's often better to use Round instead of Mround,
it can be adjusted to do the same thing without
having to load the ATP.

Regards
Martin


"Mac" wrote in message
...
I have several columns of data and I need to have them rounded (mround is
my
function of choice); but how do I insert the formula into all cells? I
tried
mround(relative reference;number) but that invokes a circular reference
error... Where do I go wrong?