EXCEL中返回3个值得公式?
EXCEL中返回3个值得公式?
日期：2013-08-13 15:46:04 人气：1
5 NG
45 NG
50 60N
55 60N
60 60N
61 60N
62 60N
63 60N
64 60N
65 65N
66 65N
67 65N
68 65N
69 65N
70 70N
71 70N
72 70N
73 70N
74 70N
75 70N
=IF(A1<50,"NG",IF(A1<65,"60N",IF(A1<70,"65N","70N"