Using Multiple IF statements w/ Values from Multiple Columns

[zuilkowski_]

I want to combine multiple IF statements from data in two columns and return a TRUE or FALSE result.

The two columns/data I am using are:

1. User Subscription Level (Basic, Pro, Premium)
2. Total Requests (Sum of values from multiple fields)

What I've tried to do so far seems to not be working very well and I am a complete novice when it comes to Airtable formulas.

IF(
  AND({Subscription} 
  = "price_1NZdQ5C8Jx0D8bOIPFa8Nlto", 
  {Total Requests}<"8"), 
  "Limit Not Reached",
IF(
   AND(
      {Subscription}
      ="price_1NkT9EC8Jx0D8bOIMXi0g37m",
      {Total Requests}>="25"
   ),
      "Limit Not Reached 2",

IF(
   {Subscription}
   ="price_1NkT9EC8Jx0D8bOIMXi0g37m"
   ),
      "Limit Not Reached 3",
      "Limit Reached"
)
)

Ultimately what I'm trying to do is check the user's subscription level and the number of requests they've submitted and evaluate if they are at their limit or under their limit.

I'm not sure if I'm fully grasping how the logic is supposed to flow and I am also thinking that because the subscription is different for each statement that might be throwing me off for how I should organize the logical statements?

Any direction would be really great as I'm trying to learn as I go.

[Sho · Accepted solution]

If "Subscription" is a single select, it would be easier to understand if it were separated.

IF({Subscription} = "price_1NZdQ5C8Jx0D8bOIPFa8Nlto",
   IF({total requests}<8,
      "Not Reached",
      "Reached"
   )
)&
IF({Subscription} = "price_1NkT9EC8Jx0D8bOIMXi0g37m",
   IF({total requests}<=25,
      "Not Reached",
      "Reached"
   )
)

[Sho]

or like this

IF({Subscription},IF(
   OR(
      IF({Subscription} = "price_1NZdQ5C8Jx0D8bOIPFa8Nlto",
         IF({total requests}<8,TRUE())
      ),
      IF({Subscription} = "price_1NkT9EC8Jx0D8bOIMXi0g37m",
         IF({total requests}<=25,TRUE())
      )
   ),
   "Not Reached",
   "Reached"
))

[zuilkowski_]

Thanks @Sho this was really helpful. Appreciate you showing a few different ways to achieve the same result.