OR function

[lunker55]

I have the formula:
=IF(Schedule!A2&Schedule!B2<>$A$2&$D$2,"",IF(Schedule!K2>($B$3+23),"",Schedu
le!J2))

I want to add OR((Schedule!A2="*"),Schedule!J2)

I want to copy the contents of J2 into the cell the formula is in if the top
formula OR the bottom formula is true.
They don't both have to be true.
Joe

 

[Trevor Shuttleworth]

Joe

not sure that I follow your question but the way to use IF and OR is as
follows:

=IF(OR(cond1, cond2, ...,condn), true_response, false_response)

In this case, if Condition 1 or Condition 2 is true (etc) return the
true_response, otherwise return the false_response

Regards

Trevor

 

[JE McGimpsey]

One way, if I understand you correctly:

=IF(OR(Schedule!A2="*", AND(Schedule!A2&Schedule!B2=$A$2&$D$2,
Schedule!K2<=($B$3+23)), Schedule!J2,"")


,""In article <#[email protected]>,

 

[lunker55]

Thanks Trevor and JE.
Works great.
Using Trevor's way, I got my formula way down in size:
=IF(OR(Schedule!A10&Schedule!B10=$B$2&$C$2,Schedule!A10="*"),Schedule!K10,""
)
Joe