View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default #VALUE in formula as opposed to result

Can you post the formula?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Spike" wrote in message
...
I have come across a formula with #VALUE actually in the formula as

opposed
to the result. What does this mean, if it is correct why would someone

code
it into the formula and what does it do as the result is a number and not
#REF or #VALUE.

Any advices will be gratefully received
--
with kind regards

Spike