Formula in a custom format

[roversam]

I have numbers show in a custom format.

Eg. I type in 9 and it shows up as A: 9.0 %
Eg. I type in 8.512 and it shows up as B: 8.5 %

The A and B are independent of the number and are based on something else completely.

But now what I need is the number to round to the nearest 0.05

Eg. I type in 9 and it shows up as A: 9.00 %
Eg. I type in 9.03 and it shows up as A: 9.05%
Eg. I type in 9.07 and it shows up as A: 9.05%
Eg. I type in 9.09 and it shows up as A: 9.10%

But, here are two concerns:
1. I do not want to use an extra column (for whatever reason)
2. I do not want the actual value to change, just the display.

Is there a way to build in the mround formula into the custom format?

 

[T. Valko]

I have numbers show in a custom format.

Eg. I type in 9 and it shows up as A: 9.0 %
Eg. I type in 8.512 and it shows up as B: 8.5 %

The A and B are independent of the number and are based on something else completely.

But now what I need is the number to round to the nearest 0.05

Eg. I type in 9 and it shows up as A: 9.00 %
Eg. I type in 9.03 and it shows up as A: 9.05%
Eg. I type in 9.07 and it shows up as A: 9.05%
Eg. I type in 9.09 and it shows up as A: 9.10%

But, here are two concerns:
1. I do not want to use an extra column (for whatever reason)
2. I do not want the actual value to change, just the display.

Is there a way to build in the mround formula into the custom format?

The short answer is NO.

You would need either an event macro or use an extra column.

 

[roversam]

Cool thanks.

 

[mikerickson]

It would drive me nuts to see 9.05 and have the underlying value be 9.03 or 9.035 or ...

At the same time, I'm perfectly comfortable with seeing 9.05 when the underlying value is 9.048

Will this format help your users or confuse them or encourage them to turn off their minds and not pay attention?

(Or is this a part of the "dumb it down so the boss understands" process?)

 

[roversam]

Someone thought that 0.05 is better than both 0.1 and .01
Obviously I think 0.1 is sufficient, but clearly someone was not happy with that and went with a ridiculous middle ground.