Thanks for your response, Tim, but neither worked :(

"Tim C" wrote:

Try:

+IF(ISNUMBER(B2),0.5,0)

or

+ISNUMBER(B2)/2

Tim C

"Teri" wrote in message
...
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))