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

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!

Page 1 / 1

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

IF(

  AND(

    ({FPL}*100) >= 125,

    ({FPL}*100) <= 300

  ),

  "Eligible"

)

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

IF(

  AND(

    ({FPL}*100) >= 125,

    ({FPL}*100) <= 300

  ),

  "Eligible"

)

This worked. Thank you so much!

Sign up