Formula to return "eligible" if percentage of FPL is between 125% and 300%

[Rachel_Royal]

Hi, 

I am trying to create a formula that accomplishes the following but am not quite sure how to set it up. Does anyone have any suggestions? 

IF({FPL %} > 125% but < 300% = "Eligible")

Thanks!

[Josh_Colina]

Hi Rachel! Assuming your FPL % field is a percentage, you can use this formula

IF(
  AND(
    ({FPL}*100) >= 125,
    ({FPL}*100) <= 300
  ),
  "Eligible"
)

[bubblesbabync]

This worked. Thank you so much!