+1Hey 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!
+25Hi,
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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.