Formula calculate no carry over

**pet_pas** · 11-21-2008, 05:10 AM

Hi

Need members here help me for the formula in excel. I want to calculate like 8+8=16, but i want the results is 7 (that mean 8+8=16 then 1+6=7).

Thank

**Cheeky Charlie** · 11-21-2008, 07:27 AM

I made this formula to add the digits of an integer:
=SUM(--MID(<integer>,ROW(INDIRECT("1:"& LEN(<integer>))),1))

You can copy it along a row or column to iterate.

I'm afraid I'm not sure how to put that into one cell but this is a start.

HTH

**shg** · 11-21-2008, 09:49 AM

See http://www.mathpages.com/home/kmath020.htm and http://mathforum.org/k12/mathtips/mulliss.html

This formula by Daddylonglegs:

=A1 - FLOOR(A1 - 1, 9)

**Cheeky Charlie** · 11-21-2008, 09:57 AM

Those pages made my brain sad. Isn't there a forum rule about inflicting that kind of thing on innocent forum users?

Also, cool.

**martindwilson** · 11-21-2008, 10:12 AM

or heres a udf i found that will take 66 in say a1 and return 3
=digitalroot(a1)
or if used like =DigitalRoot(SUBSTITUTE(A1,"+","")) it can do a whole string of single digit numbers in the form 6+5+7+2

Please Login or Register  to view this content.

this code came from here
http://people.revoledu.com/kardi/tut...ot.html#WhatIs

**pet_pas** · 11-21-2008, 10:43 AM

Hi all...thanks for reply and tq very much for help...

I prefer to using shg formula but i need to hide the sum of number. First I make 8+8=16...under row 16 i will hide it then next row is output for his formula.

Thanks
Peter

Formula calculate no carry over

LinkBack

Thread Tools

Rate This Thread

Display

Formula calculate no carry over

Formula for 8 + 8 = 7...

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions