i have a formula in cell A1 which is a Vlookup that returns a Blank instead of a 0 if the cell is blank. and I have another formula in B1 (IF(A1<>"",1,0)*0.85) but this one returns a value error if A1 is blank. am I making any sense at all?