How to write an `IF` and an `OR` formula

[Romileyrunner1]

Hi,
I want to write the following: (but this doesn`t work)

=IF(H75>1, OR I75<1,"A",(""))

Meaning, If value in H75 >1 OR if value in I75<1, then put in an `A`
otherwise if both statements are false, then leave blank.
Any ideas guys?
Thanks

RR1

 

[Mike H]

Hi,

The correct syntax for or is

=IF(OR(H75>1,I75<1),"A","")

But in your question you say if BOTH are false so do you mean AND

=IF(AND(H75>1,I75<1),"A","")

Mike

 

[Romileyrunner1]

Hi Mike,
I actually mean
"If either are true" then put in an "A" (that is, they don`t have to both be
true)
Thanks RR1

 

[Jacob Skaria]

Take a look at the below link
http://www.excelfunctions.net/ExcelOrFunction.html

If this post helps click Yes

 

[Mike H]

In that case the OR formula I posted does what you want

Mike

 

[Jacob Skaria]

Missed to copy the below..
http://www.excelfunctions.net/ExcelIf.html

If this post helps click Yes

 

[Bob Phillips]

Missed to copy the below..
http://www.excelfunctions.net/ExcelIf.html

Where it says nothing about AND/OR in an IF function!

 

[Jacob Skaria]

Bob, from the query I fealt that the OP only seem to have a problem with OR
function. Should have been...Thanks..

=IF(AND(condition1,condition2,...), TRUE statement, FALSE statement)
=IF(OR(condition1,condition2,...), TRUE statement, FALSE statement)

 

[Bob Phillips]

<G> The site looks quite good, but that page was just no help for this
question.

Where are you Jacob, you seem to post quite early my time (UK).

 

[Romileyrunner1]

Still stuck! Can anyone help.
Need to know .....
If either statement is true then put an "A", otherwise leave blank.
Thanks

 

[Jacob Skaria]

Have you tried the below formula Mike has posted ?

=IF(OR(H75>1,I75<1),"A","")

In general

'AND() returns true only if all conditions are satisfied
=IF(AND(condition1,condition2,...), TRUE statement, FALSE statement)

'OR() returns true if any one of the condition is met
=IF(OR(condition1,condition2,...), TRUE statement, FALSE statement)

If this post helps click Yes

 

[Romileyrunner1]

Thanks Mike.
works fine now.
RR1

In that case the OR formula I posted does what you want

Mike

 

[Romileyrunner1]

Thnaks for your time Jacob.
Yep, that`s the one.
Cheers
RR1

 

[Bob Phillips]

No Jacob, this email has stopped delivering some time ago (although oddly I
can send from it!).

Try me on bob at xldynamic dot com (do the obvious).