#VALUE!
 

A reference in my if-then statement refers to a another cell with a formula
where when it's true it contains a text string that appears like a number.
When the result of the reference cell is false (or is null), my if-then
statment still recognizes something in the cell and gives me "#VALUE". I want
to return a blank cell result if the reference cell is blank also. How do I
do that? To get my desired result, I've tried different commands like 0,
isblank and isnumber all to no avail.
Primary formula:
=IF(ISBLANK(Z50),"",FIXED(CONCATENATE((MID(Z50,1,2 )),$G$3,(MID(Z50,3,9))),9))

Reference cell (Z50): =VLOOKUP(P50,dws_data,8,FALSE)

Thanks

Steve

#VALUE!
 

Have you tried ISNULL()?

"Steve" wrote:

A reference in my if-then statement refers to a another cell with a formula
where when it's true it contains a text string that appears like a number.
When the result of the reference cell is false (or is null), my if-then
statment still recognizes something in the cell and gives me "#VALUE". I want
to return a blank cell result if the reference cell is blank also. How do I
do that? To get my desired result, I've tried different commands like 0,
isblank and isnumber all to no avail.
Primary formula:
=IF(ISBLANK(Z50),"",FIXED(CONCATENATE((MID(Z50,1,2 )),$G$3,(MID(Z50,3,9))),9))

Reference cell (Z50): =VLOOKUP(P50,dws_data,8,FALSE)

Thanks

Steve

#VALUE!
 

ISNULL, that is in VBA only.



--


Regards,


Peo Sjoblom

"Sean Timmons" wrote in message
...
Have you tried ISNULL()?

"Steve" wrote:

A reference in my if-then statement refers to a another cell with a
formula
where when it's true it contains a text string that appears like a
number.
When the result of the reference cell is false (or is null), my if-then
statment still recognizes something in the cell and gives me "#VALUE". I
want
to return a blank cell result if the reference cell is blank also. How do
I
do that? To get my desired result, I've tried different commands like 0,
isblank and isnumber all to no avail.
Primary formula:
=IF(ISBLANK(Z50),"",FIXED(CONCATENATE((MID(Z50,1,2 )),$G$3,(MID(Z50,3,9))),9))

Reference cell (Z50): =VLOOKUP(P50,dws_data,8,FALSE)

Thanks

Steve

#VALUE!
 

Instead of ISBLANK which will return FALSE if the cell contains a formula
use


IF(Z50="","",the rest


--


Regards,


Peo Sjoblom

"Steve" wrote in message
...
A reference in my if-then statement refers to a another cell with a formula
where when it's true it contains a text string that appears like a number.
When the result of the reference cell is false (or is null), my if-then
statment still recognizes something in the cell and gives me "#VALUE". I
want
to return a blank cell result if the reference cell is blank also. How do
I
do that? To get my desired result, I've tried different commands like 0,
isblank and isnumber all to no avail.
Primary formula:
=IF(ISBLANK(Z50),"",FIXED(CONCATENATE((MID(Z50,1,2 )),$G$3,(MID(Z50,3,9))),9))

Reference cell (Z50): =VLOOKUP(P50,dws_data,8,FALSE)

Thanks

Steve