#VALUE!

[Steve]

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

 

[Sean Timmons]

Have you tried ISNULL()?

 

[Peo Sjoblom]

ISNULL, that is in VBA only.



--


Regards,


Peo Sjoblom

 

[Peo Sjoblom]

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


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


--


Regards,


Peo Sjoblom