www.1862.net > ExCEl A1大于或小于B1则显示为1,A1等于B1则显示为...

ExCEl A1大于或小于B1则显示为1,A1等于B1则显示为...

=IF(AND(A1<>C1,B1<>C1),1,0)或=IF(AND(A1=C1,B1=C1),0,1)或=(A1<>C1)*(B1<>C1)

在b1中输入或复制粘贴下列公式 =if(a1500,a1,500) 或 =max(a1,500)

B1录入公式:=IF(A1 评论0 0 0

在C1输入公式=IF(A1>=B1*2,"超大",IF(A1>B1,"大","小")),向下拖动填充即可.

=IF(A1>B1,A1,IF(A1<B1,C1))

在b1单元格输入如下公式即可 =min(a1,a2)

输入以下公式=if(a1

B1单元格写入公式=IF(A1>=10,"大",IF(A1<10,"小","")) 或=IF(A1="","",IF(A1<10,"小","大"))

输入=IF((A1=C1)*(B1=D1),A1&B1,"")

=TEXT(A1-B1,"1;-1;0")

相关搜索:

网站地图

All rights reserved Powered by www.1862.net

copyright ©right 2010-2021。
www.1862.net内容来自网络,如有侵犯请联系客服。zhit325@qq.com