formula with text and rounding
Errata.... I wrote:
This only rounds the __appearance__, not the actual
value. so 3.105 will appear as 3.11x, but 3 times
that cells will result in 9.32 (really 9.315), not 3.33.
A hopefully obvious typo: that should be 9.33.
And I should add: unless you set the "Precision as displayed" option. (Not
recommended.)
|