第一个
Public Function 根数(rng14 As Range, rng15 As Range, rng16 As Range, rng17 As Range)
Select Case rng14.Value
Case "箍筋"
Select Case rng15.Value
Case "100"
根数 = RoundUp((rng16 - 100) / 100) + 1
Case "100/150"
根数 = 2 * (RoundUp((1.5 * rng17 - 50) / 100) + 1) + RoundUp((rng16 - 3 * rng17) / 150) - 1
Case "100/200"
根数 = 2 * (RoundUp((1.5 * rng17 - 50) / 100) + 1) + RoundUp((rng16 - 3 * rng17) / 200) - 1
Case "拉筋"
Select Case rng15.Value
Case "100"
根数 = RoundUp((rng16 - 100) / 200) + 1
Case "100/150"
根数 = RoundUp((rng16 - 100) / 300) + 1
Case "100/200"
根数 = RoundUp((rng16 - 100) / 400) + 1
End Select
End Select
End Function
第二个
Public Function 乘积(rng22 As Range, rng23 As Range, rng24 As Range)
Select Case rng1.Value
Case "顶部通长筋"
乘积 = Product(rng22, rng23, rng24)
Case Else
乘积 = ""
End Select
End Function
æä¹æè§æ²¡ææ¹åä¸ç¹ä¸è¥¿ï¼ç¬¬äºä¸ªæåéäºæ²¡æå®ä¹rng1
追çä½ ç¨selcet caseåµå¥ï¼æ¹å¨é½çä¸åºæ¥ï¼å°±è¯æè¿ç§åæ³æå¤å·®å²äºå§ã
å½æ°1çé®é¢ï¼ä½ å°äºä¸ªend selectãåªæ¹äºç»æï¼å 容没æ¹ï¼ä¸ç¥éä½ è¦å¹²ä»ä¹ã
å½æ°2ç»æä¸æ²¡é®é¢ï¼æ²¡æ¹ã
å¦å¤ï¼ç¼©è¿ç¨Tabï¼ä¸è¦èªå·±æ²ç©ºæ ¼ï¼å±æ¬¡ä¸ææ¾ã
åµå¥çæ¶åï¼ä½ å¯ä»¥éæ©ç¨ifåselect case交æ¿è¿è¡ã
'ç®æ³ä¸ä¹å¯ä»¥ä¼å