It is all made in one simple query: =IF(S2+T2+U2<V2/2,T2,IF(S2+T2+U2>V2,T2/2,T2*0.66)) This is my Scenario 32, so few CAs, and CVs use different Guns in initial models, but since those guns have identical statistics in stock, there should be no difference, except name.