Help needed with weighted ranking formula

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

Can you please elaborate more what result you need it seems to me sounds confusing about

" for one the lower value is better and the other two the higher value is better."

what results do you need then??

thanks Rev12

I have three attributes/values

MFD - the lower value the better
GFW & kgs - the higher value the better

I want to create a ranking/index system where each of three attributes have percentage value attached to create the index/ranking value.

The problem is for one of the three attributes the lower value is the better so I'm unsure how to incorporate that into my formula.

Spreadsheet was attached to my original post.

Hope that clears up any confusion

500-MFD, and you have the more the better

Thanks, but why 500?

My guess
No strike?

If I do 200 then the results seem to make more sense, I wasn't getting numbers in the index column above and below 100 otherwise (100 being the average). The animals scoring less than 100 would then be below average and the ones scoring above 100 being above average.

Thanks shg - hopefully the attached is correct?