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

+4

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!

This topic has been closed for replies.

+12

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

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

+3

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