Displaying multiples of 10
 

Use
=ROUND(A1,-1)

replace A1 with the formula used to calculate the value in A1
or you can have the formula in B1

If you want to round up to the next multiple of 10 then use
=ROUNDUP(A1,-1)

"WavMaster" wrote:

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.