Thanks for the response, however, this is the case.

I am using the vlookup formula, =vlookup(B9,Q12:R41,2,"") which produces
"#N/A" when the lookup value cell is blank. So I decided to use an if
formula, =if(B9<0,"0,if(B90,vlookup(B9,Q12:r41,2,0))) thinking that I could
get rid of the #N/A, which I did but inherited 'false' in the cell.

"JE McGimpsey" wrote:

How is FALSE getting there?

Assuming it's due to an IF() statement, put what you want to appear in
the third argument:

=IF(A1<B1,"It's true","It's not true")

If you want the cell to *appear* blank:

=IF(A1<B1,"It's true","")




In article ,
thistooshallpass wrote: