Hi

"0" is text, 0 is a number. Since you use "0" in a calculation, it will err.

HTH. Best wishes Harald

"Brad" skrev i melding
...
I'm using the above formula to return a blank cell or a 0 if my vlookup
returns an N/A. Where this is a problem is that I have a forumlua
=vlookup(A1,range,6,false)-I1. When I use
=IF(ISNA(vlookup(A1,range,6,false)),"0",(vlookup(A 1,range,6,false))-I9 I
get
#VALUE! instead of 0. Why? Is there anyway around that? I'm trying to
automate my sheet as much as possible so that I don't have to spend time
deleting formulas etc...