IF with OR and AND

  • Thread starter Thread starter MJSlattery
  • Start date Start date
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
 
MJ,

You almost had it...

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

Beege
 
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
 
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
 
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
 
A) try Edit | Clear All and retype the formula
B) send message to the MAC group
best wishes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF with OR and AND - the Sequal 4
Excel formula for inventory problem 2
Aquiring Directory names 1
"Time between" calculated over midnight 5
Help on combining two IF statements 3
Help with IF function 3
IF(AND with date comparison 4
sum and if 4

Back
Top