Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying multiples of 10 | Excel Discussion (Misc queries) | |||
COUNTIF for multiples of 3 | Excel Worksheet Functions | |||
lookup multiples | Excel Worksheet Functions | |||
Multiples of 4 in an IF statement | Excel Worksheet Functions | |||
matching multiples fields in 1 row | Excel Worksheet Functions |