What do you get returned for:

=ISNUMBER(A2)
=ISNUMBER(A3)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Loni - RWT" wrote in message
...
I have a workbook in which I have downloaded fuel tax rates for each state
on
one sheet and on another sheet I'm trying to calculate actual tax due
based
on miles traveled in each state. On my calculation worksheet, I have one
cell (A1) for the state, one cell (A2) for miles, one cell (A3) for the
tax
rate and one cell (A4) that calculates the tax due. In cell A3, I have a
vlookup to find the tax rate from worksheet with the downloaded rates
based
on the state in cell A1. That function is working properly. However when
I
try to return a value in cell A4, which is = A2*A3, it gives me zero every
time. I was thinking that maybe it was because the info was coming from a
downloaded source & it wasn't recognizing the rate as a number. However,
if
that were the case, wouldn't it give me an error message instead of zero?
Also, when I went to the worksheet with the downloaded info & did a
calculation, omitting the vlookup, the correct value was returned.
Therefore, it can't be that excel isn't recognizing it as a number. Does
anyone have any ideas on what the difference might be? Thanks in advance
for
your help!!