excel a1 b1 a2 b2累计列公式a2=a1+b1,b1需要手动输入实际数值,累计列在b列为0的时候,a列怎样将后面的结果显示为0

excel表格中有两列数据,A列和B列对比,把A列中大于B列的数据突出,怎么操作??_百度知道在excel中,如何定义C列对应行的数值等于A列对应行数值乘以B列对应行数值_百度知道如何将excel表格中的两列数据进行绑定,即输入一列内容,下一列就相应的对应上来_百度知道The page is temporarily unavailable
nginx error!
The page you are looking for is temporarily unavailable.
Please try again later.
Website Administrator
Something has triggered an error on your
This is the default error page for
nginx that is distributed with
It is located
/usr/share/nginx/html/50x.html
You should customize this error page for your own
site or edit the error_page directive in
the nginx configuration file
/etc/nginx/nginx.conf.excel A列B列数字有1和0A B1 00 01 1例如,A列和B列同行比较,只要两列有一列为1,则结果为1,如果两列都是0,则为0,怎么写函数
C列设置if函数C1=IF(OR(A1=1,B1=1),1,IF(AND(A1=0,B1=0),0,"不为1,也不为0")),C列向下拉公式
为您推荐:
其他类似问题
扫描下载二维码

我要回帖

更多关于 a1 a2 b1 b2 c1 c2 的文章

 

随机推荐