Thank you both for you contributions.

Neither of these formulas are working. What I get is the cell displays
the formula that was typed in.


=IF(AND(EG30,OR(EK3=8,EK3<=3)),E3,0)

=IF(AND(OR(EK3=8,EK3<=3),EG30),E3,0)

I am on a MAC using OFFICE 2004. Is that my problem?

Thanks again,

Michael


--
MJSlattery
------------------------------------------------------------------------
MJSlattery's Profile: http://www.excelforum.com/member.php...o&userid=16141
View this thread: http://www.excelforum.com/showthread...hreadid=550491