| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
If by 'significant digits' you mean digits that do not equal zero, try...
=SUM(IF(ISNUMBER(MID(A2,ROW(INDIRECT("1:"&LEN(A2)) ),1)+0),IF(MID(A2,ROW(I NDIRECT("1:"&LEN(A2))),1)+00,1))) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "Chace" wrote: Is there a function I can used to return the # of significant digits of a cell value. ie. If cell A2 = 1.042, I want cell B2 to equal 3 Thanks, Chace |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return a cell contents as the result of usiing "small" | Excel Worksheet Functions | |||
| Formula to return the name of a cell | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Syntax for inferred cell references | Excel Worksheet Functions | |||
| I want to return "0" based on another cell | Excel Worksheet Functions | |||
Threaded Mode
