Try:
Code: Select all
=LET(aa,A1:C1,a,INDEX(aa,,1),b,INDEX(aa,,2),c,INDEX(aa,,3),aa+XLOOKUP(VALUE(IF(a>b,2,IF(a=b,1,0))&IF(a>c,2,IF(a=c,1,0))&IF(b>c,2,IF(b=c,1,0))),{0;1;2;12;22;100;111;122;200;210;220;221;222},{2.64,-2.4,-0.2;0.08,2.74,-2.8;2.64,5.3,-7.9;-0.3,2.4,-2.1;-6.1,5.3,-7.9;-0.3,3.4,-3.1;-0.6,3.07,-2.5;-0.9,2.74,-1.8;-6.1,6.3,-0.2;-0.9,3.74,-2.8;1.64,6.3,-7.9;-1.3,3.4,-2.1;1.64,-2.4,0.75}))