The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

# Re: Nested IF, AND/OR

Solved
1433 3
cancel
Showing results for
Did you mean:
6 - Interface Innovator

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
18 - Pluto
``````IF(
AND(
{Value A} >= 90,
{Value A} <= 150,
MOD( {Value A}, 5) = 0
),
"Good",
)
``````
4 Replies 4
18 - Pluto
``````IF(
AND(
{Value A} >= 90,
{Value A} <= 150,
MOD( {Value A}, 5) = 0
),
"Good",
Oops. That should be `MOD() = 0` I edited it in my previous post.