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.

"Bob Phillips" wrote:

Show us your formula, and tell us what you want in its stead.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"thistooshallpass" wrote in
message ...