i have created interest rate model in excel contains stochastic part created norminv() command. error #num!. know how can create function assigns value cells text #num! in them.
i have tried if function didnt work didnt see #num! logical outcome, e,g, if(b3=#num!, "2").
or perhaps missunderstood.
thank in advance!
use iferror()
for example iferror(b3;"2")
Comments
Post a Comment