As stated in my response, I had presumed you had real numbers in A1. The
earlier was meant to indicate the correct way to use OR, and to highlight
that LEFT will always return spliced numbers as text, unless coerced with an
arithmetic op, eg: the "+0". Anyway, its good to see you got it working
since, with David's help/response.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Marie FP" wrote in message
...
Thanks, Max. I tried the formula, but it now shows a value of "Doesn't
Equal" in all cases, even when the first two numbers in B and C equals the
number in A. Also, when there are no numbers in either of the three
columns,
the formula leaves the "#VALUE!" error message again. Is there something
else I can try?
Marie