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