Help

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

Topic Labels: Formulas
545 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Rachel_Royal
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

2 Replies 2
Josh_Colina
6 - Interface Innovator
6 - Interface Innovator

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!