You get a NAME error when your formula has a misnamed function or
is attempting to use a defined name that does not exist. If the
function you are using is part of the Analysis ToolPak, you'll
need to load that add-in. Go to the Tools menu, choose Add-Ins,
and put a check next to Analysis ToolPak.

You should post here the formula that is giving you the error.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Freddo" wrote in message
...
I am doing a formula in excel and it is bring up the result of
#NAME? how do
I produce the result as blank