if formula dependent on the value of cells

Hi, I have a table with actual results and metrics for what these mean e.g:

Measurement Result Excellent Good Average Poor
Number of Apples 45 50 40 30 20
Number of Bananas 30 10 20 30 40

I need a formula that will generate either 'excellent', 'good', 'average' or 'poor' depending on the result and the metrics specified. I must have only one formula because the sheet will not be used by me and the details will be put in by other users. So I need a formula that will calculate it depending on whether the higher the better or the lower the better...if this makes sense...so something like if excellent is less than good do this and if excellent is more than good do this.

have the following formula:
=IF((S50>=J50),"Excellent",(IF(OR(S50<P50),"Poor",(IF(OR(S50<M50),"Average","Good")))))

This works perfectly for when the higher the better but it doesn't take into account when the lower the better....

Any help would be much much appreciated

hi, apologies, i should have done this in the first place.
here it is, i hope it makes more sense now i want formulas in the results columns...it needs to be one formula!
thank you

hmm i need the sequence to stay the same because the sheet will not be used by me, the user will put the values in and i don't want them to have to adjust the layout. i need the formula to look at whether the 'excellent' value is higher or lower than the 'good' value and then do the calculation...if this makes sense!

Hi dredwolf thank you so much, both solutions work perfectly.