IF with OR and AND

[MJSlattery]

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

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

If not what is the normal work around?

Thank you! Sincerely,

Michael

[Beege]

MJ,

You almost had it...

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

Beege


"MJSlattery" <[email protected]> wrote
in message news:[email protected]...
>
> Is there a way to use OR and AND in an IF statement?
>
> =IF(OR(EK3>=8,EK3<=3)(AND(EG3>0),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
>

[Chip Pearson]

Try

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"MJSlattery"
<[email protected]> wrote
in message
news:[email protected]...
>
> Is there a way to use OR and AND in an IF statement?
>
> =IF(OR(EK3>=8,EK3<=3)(AND(EG3>0),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
>

[MJSlattery]

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

[SimonCC]

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
>
>

[MJSlattery]

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

[Bernard Liengme]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>