ifblank function
 

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

ifblank function
 

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)
--
If this post helps click Yes
---------------
Jacob Skaria


" 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

ifblank function
 

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


;332255 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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=92861

ifblank function
 

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

ifblank function
 

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

ifblank function
 

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?

"Jacob Skaria" wrote:

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)
--
If this post helps click Yes
---------------
Jacob Skaria


" 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

ifblank function
 

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)


wrote:
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?

"Jacob Skaria" wrote:

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)
--
If this post helps click Yes
---------------
Jacob Skaria


" 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