Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
avi avi is offline
external usenet poster
 
Posts: 195
Default GammaDist function error in error

Hello,

Some posts from 2004 relates to an Excel bug for the GammaDist
cumulative function with certain values

It looks that http://members.aol.com/iandjmsmith/Examples.xls is a
link to a VBA function that overcomes the problem, but I don't succeed
to reach it

Could someone help with the problem or with getting the VBA code for
the function?

Thanks a lot
Avi
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 837
Default GammaDist function error in error

Unfortunately, AOL has shut down web hosting, so Ian Smith no longer has a
web page. Hopefully he will get a new address at some future time. Tonight
I can send you the last posted version of his library of VBA functions.

Jerry

"avi" wrote:

Hello,

Some posts from 2004 relates to an Excel bug for the GammaDist
cumulative function with certain values

It looks that http://members.aol.com/iandjmsmith/Examples.xls is a
link to a VBA function that overcomes the problem, but I don't succeed
to reach it

Could someone help with the problem or with getting the VBA code for
the function?

  #3   Report Post  
Posted to microsoft.public.excel.programming
avi avi is offline
external usenet poster
 
Posts: 195
Default GammaDist function error in error

Thanks Jerry,

I have contacted Ian directly and he sent me the code

Regards
Avi
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
did Excel GAMMADIST parameters change?? tsterkel Excel Discussion (Misc queries) 2 June 20th 08 11:36 PM
Error handling error # 1004 Run-time error [email protected] Excel Programming 3 May 20th 08 02:23 PM
Error Handling - On Error GoTo doesn't trap error successfully David Excel Programming 9 February 16th 06 05:59 PM
GammaDist Worksheet Function Bob Excel Programming 2 August 13th 04 02:41 PM
Automation Error, Unknown Error. Error value - 440 Neo[_2_] Excel Programming 0 May 29th 04 05:26 AM


All times are GMT +1. The time now is 01:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"