Problem with nested IF_OR statement:great formula

Post your formula.
--

Regards,

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

"DOOGIE" <DOOGIE@discussions.microsoft.com> wrote in message
news:F7F9803C-C672-4391-8003-ABA4ABD8A5DA@microsoft.com...
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.

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.

Post your formula.
--

Regards,

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

"DOOGIE" <DOOGIE@discussions.microsoft.com> wrote in message
news:F7F9803C-C672-4391-8003-ABA4ABD8A5DA@microsoft.com...
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.