电子表格 A1+A2,当A2为空值 把A3加起来再除2 如:A1=2.82,A2=0,A3=2.89,B1=(A1+A3)/2A1=0.89 B1=0.89/2A2=2.82 B2=(0.89+2.82)/2A3=0 B3=空格A4=4.51 B4=(A2+A4)/2A5=0 B5=空格A6=5.4 B6=(A4+A6)/2
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/05 20:52:24
![电子表格 A1+A2,当A2为空值 把A3加起来再除2 如:A1=2.82,A2=0,A3=2.89,B1=(A1+A3)/2A1=0.89 B1=0.89/2A2=2.82 B2=(0.89+2.82)/2A3=0 B3=空格A4=4.51 B4=(A2+A4)/2A5=0 B5=空格A6=5.4 B6=(A4+A6)/2](/uploads/image/z/2536165-37-5.jpg?t=%E7%94%B5%E5%AD%90%E8%A1%A8%E6%A0%BC+A1%2BA2%2C%E5%BD%93A2%E4%B8%BA%E7%A9%BA%E5%80%BC+%E6%8A%8AA3%E5%8A%A0%E8%B5%B7%E6%9D%A5%E5%86%8D%E9%99%A42+%E5%A6%82%EF%BC%9AA1%3D2.82%2CA2%3D0%2CA3%3D2.89%2CB1%3D%28A1%2BA3%29%2F2A1%3D0.89+B1%3D0.89%2F2A2%3D2.82+B2%3D%280.89%2B2.82%29%2F2A3%3D0+B3%3D%E7%A9%BA%E6%A0%BCA4%3D4.51+B4%3D%28A2%2BA4%29%2F2A5%3D0+B5%3D%E7%A9%BA%E6%A0%BCA6%3D5.4+B6%3D%28A4%2BA6%29%2F2)
电子表格 A1+A2,当A2为空值 把A3加起来再除2 如:A1=2.82,A2=0,A3=2.89,B1=(A1+A3)/2A1=0.89 B1=0.89/2A2=2.82 B2=(0.89+2.82)/2A3=0 B3=空格A4=4.51 B4=(A2+A4)/2A5=0 B5=空格A6=5.4 B6=(A4+A6)/2
电子表格 A1+A2,当A2为空值 把A3加起来再除2 如:A1=2.82,A2=0,A3=2.89,B1=(A1+A3)/2
A1=0.89 B1=0.89/2
A2=2.82 B2=(0.89+2.82)/2
A3=0 B3=空格
A4=4.51 B4=(A2+A4)/2
A5=0 B5=空格
A6=5.4 B6=(A4+A6)/2
电子表格 A1+A2,当A2为空值 把A3加起来再除2 如:A1=2.82,A2=0,A3=2.89,B1=(A1+A3)/2A1=0.89 B1=0.89/2A2=2.82 B2=(0.89+2.82)/2A3=0 B3=空格A4=4.51 B4=(A2+A4)/2A5=0 B5=空格A6=5.4 B6=(A4+A6)/2
把问题作为内容(邮件主题一定要包含“excel”)、excel样表文件(请特别注意:要03版的(如果是03以后的,把文件“另存为”一下,类型框可以选择03的),把现状和目标效果表示出来)作为附件发来看下 yqch134@163.com
追加:b1=ia1="","",if(row()=1,a1/2,(a1+i(index(a:a,row()-1)="",(index(a:a,row()-2),(index(a:a,row()-1))/2 ,下拉复制