Re: Combo Box - HELP

Yes

=ROUND(A1/0.125,0)*0.125


--

Regards,

Peo Sjoblom

"ynissel" <ynissel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EF39FDFB-6FB3-45B7-A928-8785FE6084EF@xxxxxxxxxxxxxxxx
> I always need to round to the nearest 1/8th.
> So my function is mround(a1,.125)
> Is there a built in function that can do the same thing ?
> Thanks,
> Yosef
>
> "Peo Sjoblom" wrote:
>
> > Regarding MROUND, you can get the same result using built in functions
> > but we need to know how you want to round first
> >
> > --
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> > "ynissel" <ynissel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:B866BC51-4284-40DB-B647-E71CEE5DC274@xxxxxxxxxxxxxxxx
> > > Im not sure of their version but it seems to be an issue.
> > > The other issue I have is that I used the MRound function in the file
and
> > > since its an ADDIN in the analysis tool pack many users of my file get
> > errors
> > > ! Is there a way around this without making them install the add-in
?
> > > Thanks,
> > > Yosef
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > What version of excel are they using.
> > > >
> > > > If they're using xl97 or later, then this isn't the problem.
> > > >
> > > > ynissel wrote:
> > > > >
> > > > > I send this file to other users who dont necessarily have the same
> > version
> > > > > excell as I do - and this is causing an error message to appear.
Can
> > this be
> > > > > overcome ?
> > > > > Thanks.
> > > > >
> > > > > "Dave Peterson" wrote:
> > > > >
> > > > > > That combobox's value is text.
> > > > > >
> > > > > > Maybe you could use a helper cell that points at the linked
cell:
> > > > > > =--a1/100
> > > > > > Formatted nicely.
> > > > > >
> > > > > > ynissel wrote:
> > > > > > >
> > > > > > > I have a combo box that I formatted 0.000% and it works great.
> > But the cell
> > > > > > > its linked to - which is also formatted as % to 3 decimal
places
> > wont format
> > > > > > > as a % - and thats a displayed cell so I need it to format
> > properly.
> > > > > > >
> > > > > > > any ideas ??
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Yosef
> > > > > >
> > > > > > --
> > > > > >
> > > > > > Dave Peterson
> > > > > >
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> >
> >


.

Relevant Pages

  • Re: Combo Box - HELP
    ... I always need to round to the nearest 1/8th. ... Is there a built in function that can do the same thing? ... "Peo Sjoblom" wrote: ... >> The other issue I have is that I used the MRound function in the file and ...
    (microsoft.public.excel.misc)
  • RE: how do i shade cells that contain a formula
    ... You would need a UDF for that, nothing built in ... Regards, ... Peo Sjoblom ... "peter" wrote: ...
    (microsoft.public.excel.misc)
  • Re: Rounding Up or down to 1/2 Units
    ... Regards, ... Peo Sjoblom ... > Is there a way to round up or down in 1/2 units. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: =If() results based on cell color?
    ... Not built in, but you can find it here ... Regards, ... Peo Sjoblom ... > in the cell. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Currency in cell ref
    ... Regards ... Peo Sjoblom ... > chart label. ... > round the information to say 1 decimal point ...
    (microsoft.public.excel.worksheet.functions)