western electric rules output match value vba

[Step01]

have no idea to set a output of the data ,base on western electric rules 1-4 .because i am thinking to use if else statement to do this, but it can't ,for example western western electric rules 2 must have two out of three over or lower than average value.


https://en.wikipedia.org/wiki/Western_Electric_rules