本帖最后由 swyrlbq 于 2020-4-7 21:25 编辑
03版本
=TEXT(MAX((10^MMULT(LOG(--TEXT(MMULT(LARGE(B3:E3/2,{1,2,3;1,2,4;1,3,4;2,3,4}),{1,-1,1,1;1,1,-1,1;1,1,1,-1}),"[>]0.00;\0\.\0\0\01%")),{1;1;1;1}))^(1/2)),"[<1]!0;0.0 ")
=TEXT(MAX((10^MMULT(LOG(--TEXT(MMULT(LARGE(B3:E3/2,{1,2,3;1,2,4;1,3,4;2,3,4}),({1;2;3}<>{0,1,2,3})*2-1),"[>]0.00;\0\.\01%")),{1;1;1;1}))^0.5),"[<1]!0;0.0 ")
=TEXT(MAX((10^MMULT(LOG(--TEXT(MMULT((B3:E3/2)*({1;2;3;4}<>{1,2,3,4}),-1^({1;2;3;4}={1,2,3,4})),"[>]0.00;\0\.1%")),{1;1;1;1}))^0.5),"[<1]!0;0.0 ")
2013以上版本的
=TEXT(MAX((10^MMULT(IFERROR(LOG(MMULT(B3:E3/2*(1-MUNIT(4)),-1^MUNIT(4))),-9),{1;1;1;1}))^0.5),"[<1]!0;0.0")
95字符
=ROUND(MAX((10^MMULT(IFERROR(LOG(MMULT(B3:E3/2*(1-MUNIT(4)),-1^MUNIT(4))),-9),1+A1:A4))^0.5),1)
|