Help

Formula with multiples parameters

Topic Labels: Formulas
296 1
cancel
Showing results for 
Search instead for 
Did you mean: 
capeletimila
4 - Data Explorer
4 - Data Explorer

Hey everyone! 

Can you help me to figure it out how to properly write this formula?

IF(Result>={Goal120%},"Excellent",IF(Result={Goal100%},"Completed"),IF(Result<={Goal80%},"Partial"))

Both Result, And Goals are Columms in my table. 

Thank you all, in advance! 

1 Reply 1

Hi,
depends on what is Goal..  ?  Is it number formatted as percent? Or just text field? What if Goal is 110%? 90%?
or is it Single select with limited options? If you mean  that whole range between 80 and 120 is 'Completed', then why do you need 100?