IF Formula Help

Hobo Hunt

Im looking for help with an IF type formula that would return one of the below ratings "Strong,
Average, Weak" based on the score in the first column and the indicative range sample in the third column. Im sure its something simple but it's got me stumped at present. Thanks in advance Rob

BullandKhmer

=IF([percentage Score]@row>85,"Strong",IF([percentage Score]@row<65,"Weak","Average"))

BullandKhmer

=IF([percentage Score]@row>85,"Strong",IF([percentage Score]@row<65,"Weak","Average"))

Hobo Hunt

worked great just changed the percentages to 0.85 and 0.65 thanks for the help!