Once you've rebuilt the add-in (F7 in VS 6 or Shift+Ctrl+B in VS.NET or VS 2005), you can test it in Excel as shown below.
Notice how #NUM! is returned if Probability is out of range.
If you're interested in using the new functions, have a look at the value of =NORMSINV2(NORMSDIST2(x)) for a range of different values. This should, of course, be equal to x in all cases. You will find that our version gives a smaller error than the Excel version, =NORMSINV(NORMSDIST(x)), for all values, and that our version works reasonably well for values of x less than -5 or greater than 5, where the Excel version returns garbage.
