jgthtrotih
Well-known Member
- Joined
- Aug 28, 2009
- Messages
- 568
- Office Version
- 365
- Platform
- Windows
- Mobile
<o></o>Hi All!
<o> </o>
I need a formula to take the numbers listed in cells D4:D50
<o> </o>
If below 1,000,000 than just keep that number value
<o> </o>
EXAMPLE DATA
<o> </o>
If the Ten Thousands place is 5 or below leave the same if it is higher round up. (use this concept for ALL PLACE VALUES
<o> </o>
1,500,000 to 1.5 million (if the rest are zeros)
<o> </o>
4,000,000 to 4 million
<o> </o>
1,564,535 than to 1.57 million
<o> </o>
1,545,535 than to 1.54 million
<o> </o>
1,555,000 than to 1.55 million
<o> </o>
Same concept for the rest as the Millions (move the rounded place up as needed)
<o> </o>
So for Billions it would be 10 Millions place (to round form) I think lol
<o> </o>
1,000,000,000 to 1 Billion
<o> </o>
1,500,000,000 to 1.5 Billion
<o> </o>
1,560,000,000 to 1.57 Billion
<o> </o>
1,578,000,000 to 1.58 Billion
<o> </o>
1,700,000,000 to 1.7 Billion
<o> </o>
I would like this to continue all the way up to place value 999 QUADILLION! (if possible) if the value can go bigger that would be great!
<o> </o>
<o></o>Return the answers in E4:E50
i think i explained my problem well but if not let me know!
<o></o>
<o> </o>
I need a formula to take the numbers listed in cells D4:D50
<o> </o>
If below 1,000,000 than just keep that number value
<o> </o>
EXAMPLE DATA
<o> </o>
If the Ten Thousands place is 5 or below leave the same if it is higher round up. (use this concept for ALL PLACE VALUES
<o> </o>
1,500,000 to 1.5 million (if the rest are zeros)
<o> </o>
4,000,000 to 4 million
<o> </o>
1,564,535 than to 1.57 million
<o> </o>
1,545,535 than to 1.54 million
<o> </o>
1,555,000 than to 1.55 million
<o> </o>
Same concept for the rest as the Millions (move the rounded place up as needed)
<o> </o>
So for Billions it would be 10 Millions place (to round form) I think lol
<o> </o>
1,000,000,000 to 1 Billion
<o> </o>
1,500,000,000 to 1.5 Billion
<o> </o>
1,560,000,000 to 1.57 Billion
<o> </o>
1,578,000,000 to 1.58 Billion
<o> </o>
1,700,000,000 to 1.7 Billion
<o> </o>
I would like this to continue all the way up to place value 999 QUADILLION! (if possible) if the value can go bigger that would be great!
<o> </o>
<o></o>Return the answers in E4:E50
i think i explained my problem well but if not let me know!
<o></o>