RSS iconTwitter iconFacebook icon

The Trek BBS title image

The Trek BBS statistics

Threads: 137,849
Posts: 5,328,089
Members: 24,552
Currently online: 787
Newest member: SpammetySpam

TrekToday headlines

Cubify Star Trek 3DMe Mini Figurines
By: T'Bonz on Jul 11

Latest Official Starships Collection Ships
By: T'Bonz on Jul 10

Seven of Nine Bobble Head
By: T'Bonz on Jul 9

Pegg The Prankster
By: T'Bonz on Jul 9

More Trek Stars Join Unbelievable!!!!!
By: T'Bonz on Jul 8

Star Trek #35 Preview
By: T'Bonz on Jul 8

New ThinkGeek Trek Apparel
By: T'Bonz on Jul 7

Star Trek Movie Prop Auction
By: T'Bonz on Jul 7

Drexler: NX Engineering Room Construction
By: T'Bonz on Jul 7

New Trek Home Fashions
By: T'Bonz on Jul 4


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: Magic realism
Re: Microsoft Excel question

Does http://support.microsoft.com/kb/214053 work for you?
__________________
"Sans le canard de Vaucanson vous n'auriez rien qui fit ressouvenir de la gloire de la France." -- Voltaire -- 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: Magic realism
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.
__________________
"Sans le canard de Vaucanson vous n'auriez rien qui fit ressouvenir de la gloire de la France." -- Voltaire -- 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: Magic realism
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.
__________________
"Sans le canard de Vaucanson vous n'auriez rien qui fit ressouvenir de la gloire de la France." -- Voltaire -- 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 09:37 PM.

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