Excel 函数使用
发布网友
发布时间：2022-04-24 14:47
共4个回答
热心网友
时间：2023-10-17 03:36
大于等于60的放在B1单元格,B1单元格公式如下:
=IF(A1>=60,A1&"、","")&IF(A2>=60,A2&"、","")&IF(A3>=60,A3&"、","")&IF(A4>=60,A4&"、","")&IF(A5>=60,A5&"、","")&IF(A6>=60,A6&"、","")&IF(A7>=60,A7&"、","")&IF(A8>=60,A8&"、","")&IF(A9>=60,A9&"、","")&IF(A10>=60,A10,"")
小于60的放在B2单元格,B2单元格公式如下:
=IF(A1<60,A1&"、","")&IF(A2<60,A2&"、","")&IF(A3<60,A3&"、","")&IF(A4<60,A4&"、","")&IF(A5<60,A5&"、","")&IF(A6<60,A6&"、","")&IF(A7<60,A7&"、","")&IF(A8<60,A8&"、","")&IF(A9<60,A9&"、","")&IF(A10<60,A10,"")
热心网友
时间：2023-10-17 03:37
你可以这个样子去做一下
大于等于60的放在B1单元格,B1单元格公式如下:
=IF(A1>=60,A1&"、","")&IF(A2>=60,A2&"、","")&IF(A3>=60,A3&"、","")&IF(A4>=60,A4&"、","")&IF(A5>=60,A5&"、","")&IF(A6>=60,A6&"、","")&IF(A7>=60,A7&"、","")&IF(A8>=60,A8&"、","")&IF(A9>=60,A9&"、","")&IF(A10>=60,A10,"")
小于60的放在B2单元格,B2单元格公式如下:
=IF(A1<60,A1&"、","")&IF(A2<60,A2&"、","")&IF(A3<60,A3&"、","")&IF(A4<60,A4&"、","")&IF(A5<60,A5&"、","")&IF(A6<60,A6&"、","")&IF(A7<60,A7&"、","")&IF(A8<60,A8&"、","")&IF(A9<60,A9&"、","")&IF(A10<60,A10,"")
热心网友
时间：2023-10-17 03:37
答案Verygood!但用的时候要注意符号应是英文状态下录入的。
热心网友
时间：2023-10-17 03:38
书上有,不想抄!
