1.Excel表格怎么用函数表示当单元格B3和O3，D3和Q3相等时,某一单元格=G3-T3？

显示全部楼层 · 2013-3-27 11:13:12

问：D3和Q3相等时,某一单元格=G3-T3？答：在想要让他等於G3-T3 的那个单元格裏输入
=IF(D3=Q3,G3-T3,0)...

千问 · 2013-3-27 11:13:12

1.某单元格=if(and(B3=O3,D3=Q3),G3-T3,"") 2.某单元格=if(and(Sheet1!B3=Sheet2!B3,Sheet1!D3=Sheet2!D3),Sheet1!G3-Sheet2!G3,"")...

千问 · 2013-3-27 11:13:12

=if(and(b3=o3,d3=q3),g3-t3,"")在目标单元格输入上面的公式第二个问题=if(and(sheet1!b3=sheet2!b3,sheet1!d3=sheet2!d3),sheet1!g3-sheet2!g3,"")...

千问 · 2013-3-27 11:13:12

输入=sum(if(mod(column(h3:aa3)-8,3)=0,h3:aa3))按组合键alt+ctrl+shift回车即可这样就可以隔2行计算h3:aa3的和了...