A.round(A1,-2) B.round(A1,-1) C.round(A1,1) D.round(A1,2)
A.=IF(B2=""男"",IF((D2>=40,""是"",""否""),""否"")) B.=IF(AND(B2=""男"",D2>=40),""是"",""否"") C.=IF(B2=""男"",""是"",IF(D2>=40,""是"",""否"")) D.=IF(AND(B2=""男"",D2>=40),""是"",""否"")"
A.=C2+E3+E4+F3+F4 B.=C2+F4 C.=C2+E3+F4 D.=C2+E3"