Splitting Cell Contents with a comma

D

Dejan

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
 
D

Duke Carey

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
 
Top