RSS iconTwitter iconFacebook icon

The Trek BBS title image

The Trek BBS statistics

Threads: 139,674
Posts: 5,429,700
Members: 24,823
Currently online: 552
Newest member: voyagerman49


Welcome! The Trek BBS is the number one place to chat about Star Trek with like-minded fans. Please login to see our full range of forums as well as the ability to send and receive private messages, track your favourite topics and of course join in the discussions.

If you are a new visitor, join us for free. If you are an existing member please login below. Note: for members who joined under our old messageboard system, please login with your display name not your login name.


Go Back   The Trek BBS > Entertainment & Interests > Science and Technology

Science and Technology "Somewhere, something incredible is waiting to be known." - Carl Sagan.

Reply
 
Thread Tools
Old May 7 2013, 01:18 AM   #1
Tiberius
Commodore
 
Microsoft Excel question

Okay, so I was randomly poking around on Futility Closet and I came across this:

http://www.futilitycloset.com/2006/1...deney-numbers/

Now, I want to play around with this idea and see it for myself. Rather than manually work out every single number, I'm planning on using an Excel spreadsheet.

My plan for working it out is this.

In Column A, I will have the number, starting at 1 and increasing through 2, 3 and so on.

In Column B, I will have the number cubed.

Now, in Column C, I want to take the number from Column B and add the individual digits together. So if Column B had 512, Column C would return the result of 5+1+2.

And therein lies my question. Is there a formula that can do this? So far all I can think of is to use a clunk procedure in which I divide each number by 100 and ignore the decimal, then use that number to get rid of the hundreds column and then divide by ten and ignore the decimal and so on. A rather clunky solution and I'd like to know if there's anything more streamlined.
Tiberius is offline   Reply With Quote
Old May 7 2013, 01:06 PM   #2
Asbo Zaprudder
Rear Admiral
 
Asbo Zaprudder's Avatar
 
Location: Sand in the Vaseline
Re: Microsoft Excel question

Does http://support.microsoft.com/kb/214053 work for you?
__________________
"After a time, you may find that having is not so pleasing a thing, after all, as wanting. It is not logical, but it is often true." -- Spock -- Flip flap!
Asbo Zaprudder is offline   Reply With Quote
Old May 7 2013, 10:40 PM   #3
Tiberius
Commodore
 
Re: Microsoft Excel question

Unfortunately, that didn't seem to work... Came up with 64 giving the result of 7.
Tiberius is offline   Reply With Quote
Old May 8 2013, 05:03 AM   #4
Asbo Zaprudder
Rear Admiral
 
Asbo Zaprudder's Avatar
 
Location: Sand in the Vaseline
Re: Microsoft Excel question

Try this instead:

=SUMPRODUCT(MID(B1,ROW(OFFSET($A$1,,,LEN(B1))),1)+ 0)

assuming the cell containing the digits that you want to sum is B1.
__________________
"After a time, you may find that having is not so pleasing a thing, after all, as wanting. It is not logical, but it is often true." -- Spock -- Flip flap!
Asbo Zaprudder is offline   Reply With Quote
Old May 8 2013, 08:42 AM   #5
Tiberius
Commodore
 
Re: Microsoft Excel question

That did it! Thanks!

No idea how the formula works though. Where did you find it?
Tiberius is offline   Reply With Quote
Old May 8 2013, 09:04 AM   #6
Asbo Zaprudder
Rear Admiral
 
Asbo Zaprudder's Avatar
 
Location: Sand in the Vaseline
Re: Microsoft Excel question

Tiberius wrote: View Post
That did it! Thanks!

No idea how the formula works though. Where did you find it?
http://chandoo.org/wp/2011/03/18/cal...s-in-a-number/

The site explains how it works.
__________________
"After a time, you may find that having is not so pleasing a thing, after all, as wanting. It is not logical, but it is often true." -- Spock -- Flip flap!
Asbo Zaprudder is offline   Reply With Quote
Old May 8 2013, 09:58 AM   #7
Tiberius
Commodore
 
Re: Microsoft Excel question

Cheers for that!
Tiberius is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +1. The time now is 07:35 PM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
FireFox 2+ or Internet Explorer 7+ highly recommended.