Help

Nested IF, AND/OR

Topic Labels: Formulas
Solved
Jump to Solution
107 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,

I’m struggling with some nested IF, AND and OR formulas.
I’m trying to find if a value is within a range of numbers, and is a multiple of 5.

For the range, I have the formula:

IF(Value A >= 90,"Good", IF(Value A <= 150, "Bad")) <<This works

To check if Value A is a multiple of 5, I have the formula:

IF(OR(RIGHT("" & Value A,1) =0, RIGHT("" & Value A,1)=5),"Good", "Bad") << this works

The part I am struggling with is combining them together so that:
If Value A is between 90-150 and is a multiple of 5 then “Good”, otherwise “Bad”

Any ideas?

Thanks,
Scott

1 Solution

Accepted Solutions
IF(
  AND(
    {Value A} >= 90,
    {Value A} <= 150,
    MOD( {Value A}, 5) = 0
  ),
  "Good",
  "Bad"
)

See Solution in Thread

4 Replies 4
IF(
  AND(
    {Value A} >= 90,
    {Value A} <= 150,
    MOD( {Value A}, 5) = 0
  ),
  "Good",
  "Bad"
)

Thanks for your response @kuovonne however this formula returns ‘Bad’ for all values.

Oops. That should be MOD() = 0 I edited it in my previous post.

Labels