Are you trying to open it on a machine that doesn't have the Analysis
ToolPak Add-In loaded?
--
David Biddulph

"watchtower" wrote in message
...
I am using the formula =intrate(settlement,maturity,investment,redemption )
When I open up a fresh worksheet this formula is available. Once I save
and
close the worksheet, then re-open the file, the cell displays "#NAME?" and
I
can no longer use this formula. Other formulas work fine, but I cannot
even
find this formula using the function search. Any thoughts?