|
6#
發(fā)表于 2022-3-11 09:39:04
|
只看該作者
=if("d" >= 6 and "d" <8, 2, (if("d" >= 8 and "d" < 10, 3, (if("d" >= 10 and "d" <12, 4,)))))
1 s% c% i4 [5 N7 H J) f4 E6 ~“d”是軸徑,,這里是設(shè)成全局變量了, {, d, ^5 z' \: \/ C8 X
似乎SW的if只能套3層,,所以三層以內(nèi)可以按上面的,多的可以按下面思路
6 c# k8 O; Y% g& j! n+ H設(shè)全局變量
% T8 K& Y# Q; B“b1" = if("d" >= 6 and "d" <8, 2, ”b2")
8 E# U0 h3 t* t9 k"b2" = if("d" >= 8 and "d" < 10, 3, "b3")5 t3 N, L% E$ l* e2 v# G
"b3" = if("d" >= 10 and "d" < 12, 4, "b4")
8 T0 y6 J$ D& P"b4" = if("d" >= 12 and "d" < 17, 5, 6)4 b/ g( O5 U: g9 `2 @8 `
然后把鍵寬連接到"b1“ |
|