excel怎么按列提取非空单元格数值到指定的新列

excel

1个回答

写回答

=IFS(OR(A16,AND(A16,A17)),140,OR(A1={6,7}),120,OR(AND(A17,A18),AND(A18,A19)),154,OR(A1={8,9}),132,A19,0)*A1

举报有用(0分享收藏

Copyright © 2025 IZhiDa.com All Rights Reserved.

知答 版权所有 粤ICP备2023042255号