Splitting Cell Contents with a comma

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
first number in cell 2
How to split Cell content into two resulting cells 1
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX 6
Conditional format refers to two cells 1
How to use the Stop If True Condition for highlight cells 1
VBA Multiple Line handling with Split() 1
Event recognition. 6

Back
Top