LinkBack URL
About LinkBacks
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
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
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
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)
Last edited by shg; 11-21-2008 at 09:52 AM.
Entia non sunt multiplicanda sine necessitate
Those pages made my brain sad. Isn't there a forum rule about inflicting that kind of thing on innocent forum users?
Also, cool.
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
this code came from here
Please Login or Register to view this content.
http://people.revoledu.com/kardi/tut...ot.html#WhatIs
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
Last edited by pet_pas; 11-21-2008 at 10:52 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks