#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
|