ifblank function

J

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
 
J

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)
 
D

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.
 
D

Dave Peterson

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

I was wrong.
 
J

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?
 
G

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top