Forum Discussion

Copper Contributor

Jan 29, 2019

Solved

Formula Help - If/OR Function

I'm trying to write a formula that will prompt review based on certain criteria in a list. The only "true" return values I'm getting are on the argument with a greater than numberic value. Is there...

excel

Formulas and Functions

Wyn Hopkins
Jan 29, 2019
Ah ok, you'll need to do a COUNTIFS. So something like this

=IFERROR(IF(OR( COUNTIFS( Rules!B:B,A246)>0,
COUNTIFS( Rules!A:A,Q246)>0, N246<35),"","Review"),"Review")

Kristy_Jane

Copper Contributor

Jan 29, 2019

I'll try to get a sample file uploaded. Rules!A;A and Rules!B:B is referencing a range on another worksheet, same workbook. So if Q2 equals any value in the range in Column B on Rules tab, value should return "".

Wyn Hopkins

MVP

Jan 29, 2019

Ah ok, you'll need to do a COUNTIFS. So something like this

=IFERROR(IF(OR( COUNTIFS( Rules!B:B,A246)>0,
COUNTIFS( Rules!A:A,Q246)>0, N246<35),"","Review"),"Review")

Kristy_Jane
Copper Contributor
Jan 29, 2019
This worked perfectly! I tried similar, but I must have been missing a piece of the argument. thanks! Wyn Hopkins