No, I did not realize that. I tried it and it works! Excel has a lot of odd
quirks. Thank you very much!

"Ragdyer" wrote:

Do you realize that your formula is an *array* formula?
--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of
the regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"DOOGIE" wrote in message
...
=IF(OR(B55:B175100),"YES","NO")

"RagDyeR" wrote:

Post your formula.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"DOOGIE" wrote in message
...
I am using a nested IF_OR statement to evaluate a list of values to see
if
any of them are 100, and to return YES if they are, and NO if they are
not.
When I enter the formula using the formula palette, the value shown in
the
palette is NO which is correct, however #VALUE! is displayed in the
cell. I
have checked and the formula is entered correctly. I am completely
perplexed.
Any help would be appreciated.