Extending if statement output to more than 2
I'm using this formula that works - if(("score") > 75, 'Good','Poor')
This recodes score into two answers.
What is the formula code for something like - i.e. 3 output options
If score > 75 'Good'
If score < 40 'Poor'
Rest 'Average'
I'm using Zoho Reports. Think answer lies in "Else if" but can't find an example for Reports.
Regards
Mark