Cell  Formula  F2  =IF(OR(A2={"a","b"}),A2&"h"&IF(B2>C2,"w","l"),IF(OR(D2={"a","b"}),D2&"a"&IF(B2>C2,"l","w")))  F3  =IF(OR(A3={"a","b"}),A3&"h"&IF(B3>C3,"w","l"),IF(OR(D3={"a","b"}),D3&"a"&IF(B3>C3,"l","w")))  F4  =IF(OR(A4={"a","b"}),A4&"h"&IF(B4>C4,"w","l"),IF(OR(D4={"a","b"}),D4&"a"&IF(B4>C4,"l","w")))  F5  =IF(OR(A5={"a","b"}),A5&"h"&IF(B5>C5,"w","l"),IF(OR(D5={"a","b"}),D5&"a"&IF(B5>C5,"l","w")))  F6  =IF(OR(A6={"a","b"}),A6&"h"&IF(B6>C6,"w","l"),IF(OR(D6={"a","b"}),D6&"a"&IF(B6>C6,"l","w")))  F7  =IF(OR(A7={"a","b"}),A7&"h"&IF(B7>C7,"w","l"),IF(OR(D7={"a","b"}),D7&"a"&IF(B7>C7,"l","w")))  F8  =IF(OR(A8={"a","b"}),A8&"h"&IF(B8>C8,"w","l"),IF(OR(D8={"a","b"}),D8&"a"&IF(B8>C8,"l","w")))  F9  =IF(OR(A9={"a","b"}),A9&"h"&IF(B9>C9,"w","l"),IF(OR(D9={"a","b"}),D9&"a"&IF(B9>C9,"l","w")))  F10  =IF(OR(A10={"a","b"}),A10&"h"&IF(B10>C10,"w","l"),IF(OR(D10={"a","b"}),D10&"a"&IF(B10>C10,"l","w"))) 

Like this thread? Share it with others