Significant figures

Thread view:

Thread rating:

Turnipboy - 29 Dec 2005 13:24 GMT

How do I get a number to be displayed in say 2 significant figures, all
that I find in numbers formating is decimal places.

Thanks.

Signature

Turnipboy

Bernard Liengme - 29 Dec 2005 13:48 GMT

From an earlier reply by Jerry W. Lewis
=ROUND(A1, A2 - 1 - INT(LOG10(ABS(A1))))
note that you may get non significant trailing zeros
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> How do I get a number to be displayed in say 2 significant figures, all
> that I find in numbers formating is decimal places.
>
> Thanks.