I'm not familiar with Mac's, but it appears the problem may be that your cell
is formatted as text. Thus it displays your formula literally.

Change the format to General, then re-enter.

HTH,
Elkar

"MJSlattery" wrote:


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