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
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
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)+0>0,1)))
....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.
Hope this helps!
In article <[email protected]>,
"Chace" <[email protected]> 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
The value 1.042 has 4 significant digits but 0.142 has three as has 1420
Do you mean the number of decimal places?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Chace" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks