Displaying specific numbers
I need to display only numbers divisable by 10 in a cell, if the calculation
is not divisable by 10 it still needs to display in multiples of 10.
Example: The product of 100 x .102 equals 102, but the value displayed needs
to be 110. whatever the product of the formula, the display must be
multiples of 10.
|