I assumed that the extra space was a mistake in the post--not the formula.

I was wrong.

Dave Peterson wrote:

I just use:
=if(f2="",na(),e3+f2)

And W16 in that sending sheet contains a real value--not a name error, right?

The only thing I see that could cause trouble is if the second workbook is in
R1C1 reference style. W16 doesn't mean anything.

In xl2003 menus:
Tools|Options|general tab|uncheck R1C1 reference style.

If this doesn't help, you may want to copy|paste the actual formula from the
formula bar instead of typing it into your message.

wrote:

I'm using this in one spread sheet just fine:

=IF(ISBLANK(F2),NA(),E3+F2)

Trying to use this variation in another workbook and am getting the #name
error

IF(isblank ('Control Plan Results'!W16),NA(),'Control Plan Results'!W16)

Not sure why, I thought I had a type in the sheet reference so I copy and
pasted just to make sure. Any help would be great.

Derek

--

Dave Peterson

--

Dave Peterson