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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF with OR and AND - the Sequal
Hi MJSlattery,
This sounds like you cell is formatted as text. When formatted that way, anything you type into the cell is displayed as typed - even formulae. To get the formula to work, change the cell's formatting (via Format|Cells|Number) to whatever format you'd prefer (eg General, Number, Date, etc) but not Text. Then re-select your formula (not just the cell) and press <Enter Cheers -- macropod [MVP - Microsoft Word] "MJSlattery" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF with OR and AND - the Sequal
Why start another thread? hehe My suggestion, throw that mac out of the window and get a PC ;) -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=550491 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF with OR and AND - the Sequal
Thanks for the assistance. Michael -- MJSlattery ------------------------------------------------------------------------ MJSlattery's Profile: http://www.excelforum.com/member.php...o&userid=16141 View this thread: http://www.excelforum.com/showthread...hreadid=550491 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF with OR and AND - the Sequal
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|