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

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

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

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

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

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

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