Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF with OR and AND - the Sequal
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 |