IF with OR and AND

M

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
 
M

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
 
S

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
 
M

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 quot
mark in the front and back of the formula.

Tried general as well.

Michae
 
B

Bernard Liengme

A) try Edit | Clear All and retype the formula
B) send message to the MAC group
best wishes
 
Top