ifblank function

[jones.derek]

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

 

[Jacob Skaria]

Try the below...... Please note that the blank space after ISBlank is taken
off...

=IF(ISBLANK('Control Plan Results'!W16),NA(),'Control Plan Results'!W16)

 

[Simon Lloyd]

I believe it should look like this:
=IF(ISBLANK('Control Plan Results'!W16),"NA()",'Control Plan
Results'!W16)

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

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[Dave Peterson]

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.

 

[Dave Peterson]

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

I was wrong.

 

[jones.derek]

Jacob

I retyped the string and resolved the #name error.
Now in regards to the syntax, the function is getting evaluated from what I
can see. If I put a value in the referenc cell the isblack evaluates to
false and and sets the current cell to that value. But, and here is the
strange thing, if the reference cell is left empty then the current cell
stays empty. So the false condition is being exicuted but the true side is
not. I have tried as the alternate syntax, replaced na() with "NA", but
still get a blank field. Any thougts?

 

[Glenn]

Is the reference cell really empty, or is there a "space" in it? Try adding
TRIM() around your cell reference inside the ISBLANK().

=IF(ISBLANK(TRIM('Control Plan Results'!W16)),NA(),'Control Plan Results'!W16)