Tom Ogilvy wrote:
=IF(OR($B5="", $F5="Medicare", $G5="", $G5="A", $G5="P",
$G5="R",SUM($I5-$J5)=0),"","F1")

is a complete formula. Everything after it has no meaning. Perhaps you
need to put up a valid formula if you want help.

--
Regards,
Tom Ogilvy



One thing that can help to keep the formula manageable (readable) is to
enter some of the multiple choices for a single cell in an array, such
as:

=IF( OR( $F5 = "Medicare", $G5 = {"","A","P","R"}, SUM( $I5 - $J5) =
0),"","F1")

(for example)