CODEWITHSUNDEEP
excel
bn_ln
bn_ln

Reputation: 1683

Excel formating to multiples of decimals

I would like to display a value of a cell to the nearest multiple of a fraction, say 1/8th, but to preserve the actual value of the cell, ie. avoiding using the ROUND function. For example;

0.44 in [A1] would display as 0.5,

0.33 in [A2] would display as 0.375, and

=A1+A2 in [A3] would display as 0.75 (rather than 0.875)

Is it possible to format in such a manner?

Upvotes: 0

Views: 64

Answers (1)

D Stanley
D Stanley

Reputation: 152521

No, there is no formatting that can round to intervals other than decimals.

What I would do is keep your raw values in one hidden cell, then round it in another cell that references the raw value, and show that cell.

Alternatively, you can display numbers as fractions , but it doesn't simplify fractions (e.g. it will display 0.5 as 4/8)

Upvotes: 1

Related Questions