| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF with OR and AND
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF with OR and AND
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF with OR and AND
Try
=IF(AND(EG30,OR(EK3=8,EK3<=3)),E3,0) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF with OR and AND
Tried both versions, when they are placed into a cell, that cell then displays the fromula when the enter button is pressed. I am on a MAC using Office 2004. 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=550469 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF with OR and AND
Sounds like your cells is formatted as Text. Just format the cell as General
and type the formula again. You should then get the result of the formula. -Simon "MJSlattery" wrote: Tried both versions, when they are placed into a cell, that cell then displays the fromula when the enter button is pressed. I am on a MAC using Office 2004. 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=550469 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF with OR and AND
Formatted as number. There was a space in frount of the = sign. Removed that and the program comes back and wants to put a single quote mark in the front and back of the formula. Tried general as well. Michael -- MJSlattery ------------------------------------------------------------------------ MJSlattery's Profile: http://www.excelforum.com/member.php...o&userid=16141 View this thread: http://www.excelforum.com/showthread...hreadid=550469 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF with OR and AND
A) try Edit | Clear All and retype the formula
B) send message to the MAC group best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MJSlattery" wrote in message ... Formatted as number. There was a space in frount of the = sign. Removed that and the program comes back and wants to put a single quote mark in the front and back of the formula. Tried general as well. Michael -- MJSlattery ------------------------------------------------------------------------ MJSlattery's Profile: http://www.excelforum.com/member.php...o&userid=16141 View this thread: http://www.excelforum.com/showthread...hreadid=550469 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
