=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.