表格函数b=indirect(a1&"!a1")代表什么意思,能具体解释下&"!a1"更好.还有c=indirect(a1$a2&"!b"&b2+1)当我想要返回的数据含有两个以上条件的话,语法怎么用.最好汉字注解.谢谢大神们
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 14:19:25
![表格函数b=indirect(a1&](/uploads/image/z/5474111-23-1.jpg?t=%E8%A1%A8%E6%A0%BC%E5%87%BD%E6%95%B0b%3Dindirect%28a1%26%22%21a1%22%29%E4%BB%A3%E8%A1%A8%E4%BB%80%E4%B9%88%E6%84%8F%E6%80%9D%2C%E8%83%BD%E5%85%B7%E4%BD%93%E8%A7%A3%E9%87%8A%E4%B8%8B%26%22%21a1%22%E6%9B%B4%E5%A5%BD.%E8%BF%98%E6%9C%89c%3Dindirect%28a1%24a2%26%22%21b%22%26b2%2B1%29%E5%BD%93%E6%88%91%E6%83%B3%E8%A6%81%E8%BF%94%E5%9B%9E%E7%9A%84%E6%95%B0%E6%8D%AE%E5%90%AB%E6%9C%89%E4%B8%A4%E4%B8%AA%E4%BB%A5%E4%B8%8A%E6%9D%A1%E4%BB%B6%E7%9A%84%E8%AF%9D%2C%E8%AF%AD%E6%B3%95%E6%80%8E%E4%B9%88%E7%94%A8.%E6%9C%80%E5%A5%BD%E6%B1%89%E5%AD%97%E6%B3%A8%E8%A7%A3.%E8%B0%A2%E8%B0%A2%E5%A4%A7%E7%A5%9E%E4%BB%AC)
xTN@BQ Jo B>'$$-`.
Bcgv֛j_ۇZeΜs̬#d!]vԋ^]{_ٚj2H:UNL3\;.8K=ˊPwC|tJfa@,B{l|t,,ׁW̥v7ԩS{Wxm?b>!Vґf}M+v/ӊ6E>_/42?z:nX`{R5%rU>:RudV}B#.J>d'].8QEre
@v/+J{Աr$>AzʀJ@LG|Bf!:BHPe-A`,NA:e jT ׇ]xb1|3~I$S%,