I have used the "ROUND" in the formula however it only rounds to the nearest
number not the nearest number divisible by 10

here is the formula that works for the problem, but it does not give me the
desired result as I need only display multiples of 10 for the input of other
data to finalize the operation
=ROUND(MIN(10)*B8*0.202,0)+98
in this formula "B8" can equal any number from 1 to 1000
if B8=1 the resulting product equals 100 which is the minimum value I can
allow
when B8=100 the resulting product equals 300 which is the desired result
when B8=numbers between 1 & 6, 7 & 11, 12 & 16 and so on the result is not
divisible by 10


"Sheeloo" wrote:

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.