View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default significant digits

On Mon, 29 Sep 2008 15:28:43 -0700 (PDT), Bernd P wrote:

Hi Ron,

Your UDF returns for RSD(0.99,2)=1.0

My UDF Dbl2NSig results in 0.99:
http://www.sulprobil.com/html/dbl2nsig.html

Regards,
Bernd


Your correct. I posted in error.

WRT your UDF, why not modify it so it also handles negative numbers?

=dbl2nsig(-0.99,3) -- "0.-.9"
--ron