Your formula as written works for me in XL97

--
Regards

Sandy

Replace@mailinator with @tiscali.co.uk


"MichaelC" wrote in message
...
I have the following formula which I believe does not breach any rules, yet
it returns an error message. Can anyone see where my error is? I would
much
appreciate any help, and thank you in advance.
I don't believe I am breaching the max 7 arguments rule.

=if(OR
(AND(J44="GreenAbove",J43="GreenAbove",J42="RedBel ow"),
AND(J44="GreenAbove",J43="GreenBelow",J42="RedBelo w"),
AND(J44="GreenBelow",J43="GreenBelow",J42="GreenBe low",J41="RedBelow")),
C44,"")