The Trek BBS statistics

Posts: 5,843,277
Members: 26,187
Currently online: 442

Retro Review: Non Sequitur
By: Michelle Erica Green on Sep 4

Two The Next Generation Bobble Heads
By: T'Bonz on Sep 4

September-October 2015 Trek Conventions And Appearances
By: T'Bonz on Sep 4

Official Starships Collection Update
By: T'Bonz on Sep 3

Star Trek Night At Fenway Park
By: T'Bonz on Sep 3

New Star Trek Merchandise
By: T'Bonz on Sep 2

Perth Mint Voyager Coins
By: T'Bonz on Sep 1

Face Off To Feature Trek Makeup
By: T'Bonz on Sep 1

Pegg Omaze Video Features Outtakes
By: T'Bonz on Sep 1

Vulcan Ale – The Genesis Effect
By: T'Bonz on Aug 31

 The Trek BBS Microsoft Excel question

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

 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. __________________
 May 7 2013, 01:06 PM #2 Asbo Zaprudder Rear Admiral     Location: On the beach Re: Microsoft Excel question Does http://support.microsoft.com/kb/214053 work for you?
 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. __________________
 May 8 2013, 05:03 AM #4 Asbo Zaprudder Rear Admiral     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.
 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? __________________
May 8 2013, 09:04 AM   #6
Asbo Zaprudder

Location: On the beach
Re: Microsoft Excel question

 Tiberius wrote: 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.

 May 8 2013, 09:58 AM #7 Tiberius Commodore Re: Microsoft Excel question Cheers for that! __________________

 Bookmarks