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")

Wyn Hopkins

MVP

Jan 29, 2019

Hi Kristy_Jane

Could you post a sample file to show what you are trying to do ?

I'm a bit confused by the A246=Rules!B:B,Q246=Rules!A:A part

Thanks

Wyn

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