| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Splitting Cell Contents with a comma
Hello,
Is it possible to split contents of a cell based on if the cell value is greater than 10000000, if true the result would be 1,000,0000, if not copy the cell value. All the numbers are either heigher or lower than 10000000. Thanks Dejan |
|
#2
|
|||
|
|||
|
It's not clear whether you mean one million or ten million. For one million
use the formula: =MIN(cell with value,1000000) If it's ten million, add a zero "Dejan" wrote: Hello, Is it possible to split contents of a cell based on if the cell value is greater than 10000000, if true the result would be 1,000,0000, if not copy the cell value. All the numbers are either heigher or lower than 10000000. Thanks Dejan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
| Cell contents as the 'lookup value' parameter in HLOOKUP function | Excel Discussion (Misc queries) | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| cell contents | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
