A B C D E
F
Shipment # Quote # Date Actual GP Gross Revenue Total Points
LAX 2056512 406213 02/10/05 65.41% $82.50 2.5

For the data above, I have a VLOOKUP table to determine points for GP %
achieved. However, .5 point is awarded if a Quote # is entered. I have the
following formula in Column F which returns the correct amount of points, but
in a blank line, the formula also displays .5 I thought if I entered IS
NOT NULL in the formula, I would get the correct answer but I get an error
message. What am I doing incorrectly?

=(VLOOKUP(D2,$H$2:$J$6,3)+IF(B20,0.5,0))