>Hilmar,
>
>This is exactly what I have done, simply automating excel to access the functions, in this case NORMSINV(x), works fine if a little slow.
OK.
According to the description I found in help - if I have the correct function, for I use Excel in Spanish - the function uses an iterative process.
If you know what normsinv() is the inverse of, you might do something similar in a UDF. This might run faster than Excel Automation.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)