Thread: NOSMSDIST Limit
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
crapatmath
 
Posts: n/a
Default NOSMSDIST Limit

Hi All,

Why is
1-NORMSDIST(7.8) = 3.10862e-15
while
1-NORMSDIST(7.9) = 0

Is there a limit to how far out the Gaussian PDF curve you can go before
Excel rounds to zero?

Thanks

Barry