I am looking to create a ranking system for my sheep, where I have three attributes and have weighted their contribution percentage to my ranking system.
I can do a basic ranking formula, but the problem I have is that I am using three attributes and for one the lower value is better and the other two the higher value is better.
MFD - the lower the value the better
GFW & kgs - the higher the value the better
How do I account of this in my formula? I have attached a copy of my spreadsheet.
Any help is greatly appreciated please![]()
Bookmarks