RSS iconTwitter iconFacebook icon

The Trek BBS title image

The Trek BBS statistics

Threads: 135,748
Posts: 5,215,962
Members: 24,214
Currently online: 795
Newest member: GregLock

TrekToday headlines

Q Meets NuTrek Crew
By: T'Bonz on Apr 18

Pine In Talks For Drama
By: T'Bonz on Apr 18

New X-Men: Days of Future Past Trailer
By: T'Bonz on Apr 17

Nimoy to Receive Award
By: T'Bonz on Apr 17

Star Trek Special: Flesh and Stone Comic
By: T'Bonz on Apr 16

These Are The Voyages TOS Season Two Book Review
By: T'Bonz on Apr 16

Kirk’s Well Wishes To Kirk
By: T'Bonz on Apr 15

Quinto In New Starz Series
By: T'Bonz on Apr 15

Star Trek: Horizon Film
By: T'Bonz on Apr 14

Star Trek: Fleet Captains Game Expansion
By: T'Bonz on Apr 14


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 02:31 PM.

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