| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing up digits in a cell
... this has helped for two digits.
Another option for 1-2 digit numbers ... =A1-9*INT(A1/10) -- Dana DeLouis "Sai Krishna" wrote in message ... Thanks gaurav, this has helped for two digits. regards krishna "Gaurav" wrote: If you only have 2 digits, try this =SUM(LEFT(A2,1),RIGHT(A2,1)) "Sai Krishna" wrote in message ... Hi, i need to add all the digits in a cell. For example, if I have a number 58 in a cell, the adjacent cell should return a value of 13. regards krishna |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove all but the last seven digits in a cell | Excel Discussion (Misc queries) | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| Type 3 digits in one cell then automatically move to next cell. | Excel Discussion (Misc queries) | |||
| 19 Digits in a Cell | Excel Discussion (Misc queries) | |||
| 12 or more digits in a cell | New Users to Excel | |||
Threaded Mode
