MJ,

You almost had it...

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

Beege


"MJSlattery" wrote
in message ...

Is there a way to use OR and AND in an IF statement?

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

If not what is the normal work around?

Thank you! Sincerely,

Michael


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