RSS iconTwitter iconFacebook icon

The Trek BBS title image

The Trek BBS statistics

Threads: 143,086
Posts: 5,594,448
Members: 25,384
Currently online: 680
Newest member: Phaser Dolphin

TrekToday headlines

Hurley Passes
By: T'Bonz on Feb 26

USS Excelsior Model Coming Soon
By: T'Bonz on Feb 25

Hemsworth To Host SNL
By: T'Bonz on Feb 25

Quinto To Guest Star On HBO Comedy
By: T'Bonz on Feb 25

Wheaton To Voice Firefly Game
By: T'Bonz on Feb 24

Nimoy Health Scare
By: T'Bonz on Feb 24

Star Trek #42 Preview
By: T'Bonz on Feb 23

Trek Actors At The Oscars
By: T'Bonz on Feb 23

Retro Review: The Changing Face of Evil
By: Michelle on Feb 21

Star Trek-Themed Van Sold
By: T'Bonz on Feb 20


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: On the beach
Re: Microsoft Excel question

Does http://support.microsoft.com/kb/214053 work for you?
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: On the beach
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.
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: On the beach
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.
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 06:24 PM.

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