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.

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.

=CEILING(102,10)

HTH. Best wishes Harald

"WavMaster" wrote in message
...
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.

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.
--
David Biddulph

WavMaster wrote:
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.

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))

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1

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
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1