Displaying multiples of 10

[WavMaster]

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.

 

[WavMaster]

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

 

[Harald Staff]

=CEILING(102,10)

HTH. Best wishes Harald

 

[David Biddulph]

Sheeloo said:
Use =ROUND(...,-1)
Why not try that?

Hint: ROUND(...,0) gives a different result from ROUND(...,-1)
If you need to know more about the ROUND function, look it up in Excel help.

 

[Chris Bode via OfficeKB.com]

Use following formula,
Let the values are in column A and you want the corresponding values in
Column B the numbers divisible by 10,
Select a cell in column B and paste following formula
=IF((A1-TRUNC(A1,-1))>=5,TRUNC(A1,-1)+10,TRUNC(A1,-1))

 

[Chris Bode via OfficeKB.com]

Use following formula,
Let the values are in column A and you want the corresponding values in
Column B the numbers divisible by 10,
Select a cell in column B and paste following formula
=IF((A1-TRUNC(A1,-1))>=5,TRUNC(A1,-1)+10,TRUNC(A1,-1))






Chris