RSS iconTwitter iconFacebook icon

The Trek BBS title image

The Trek BBS statistics

Threads: 139,616
Posts: 5,426,122
Members: 24,810
Currently online: 398
Newest member: 8 of 9

TrekToday headlines

IDW Publishing December Trek Comics
By: T'Bonz on Sep 17

September Loot Crate Features Trek Surprise
By: T'Bonz on Sep 16

USS Enterprise Miniature Out For Refit
By: T'Bonz on Sep 16

Star Trek/Planet of the Apes Comic Crossover
By: T'Bonz on Sep 16

Trek 3 Shooting Next Spring?
By: T'Bonz on Sep 16

Star Trek: Alien Domain Game Announced
By: T'Bonz on Sep 15

Red Shirt Diaries Episode Three
By: T'Bonz on Sep 15

Made Out Of Mudd Photonovel
By: T'Bonz on Sep 15

Takei Has Growth Removed
By: T'Bonz on Sep 15

Retro Review: Tears of the Prophets
By: Michelle on Sep 12


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 05:12 AM.

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