Formula with multiples parameters

capeletimila · ‎Aug 25, 2023

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!

Alexey_Gusev · ‎Aug 26, 2023

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?