Combo Box - HELP
Yes
=ROUND(A1/0.125,0)*0.125
--
Regards,
Peo Sjoblom
"ynissel" wrote in message
...
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" wrote in message
...
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
|