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”
Solved! Go to Solution.