| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying specific numbers
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying specific numbers
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. "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 | |||
| Selecting specific numbers from a cell containing multiple numbers | Excel Worksheet Functions | |||
| Displaying -ve numbers | Excel Discussion (Misc queries) | |||
| Displaying all numbers as positive | Excel Worksheet Functions | |||
| Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
| Displaying value of specific cell within a range, with IF function...? | Excel Discussion (Misc queries) | |||
Hybrid Mode
