I have to folowing formula entered into an A___:E___ array:

=IF(OR('Division 2'!F1:F540=".",'Division 2'!F1:F540="c"),'Division
2'!A1:E540,"")

What I want it to do is carry over the A:E cells of any row where the column
F cell content is either "c" or "." (period). I can succesfully do this with
1 criteria test, without the OR function. But once I put the OR function in
with the choice of "C" or ".", I get the entire array returned to my summary
form, basically the OR function is always TRUE.

Does anyone see my error?