EXCEL函数公式表示什麼意思?在一个excelk中(数据库)有一下列公式,但太复杂了,看不懂,有哪位高手解说下,此公式表示何意思?=IF(OR($H3="",C3=""),"",IF(VLOOKUP($H3,数据库!$A$2:$S$10000,MATCH(F$2,数据库!$A$
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/17 20:06:57
![EXCEL函数公式表示什麼意思?在一个excelk中(数据库)有一下列公式,但太复杂了,看不懂,有哪位高手解说下,此公式表示何意思?=IF(OR($H3=](/uploads/image/z/1782883-19-3.jpg?t=EXCEL%E5%87%BD%E6%95%B0%E5%85%AC%E5%BC%8F%E8%A1%A8%E7%A4%BA%E4%BB%80%E9%BA%BC%E6%84%8F%E6%80%9D%3F%E5%9C%A8%E4%B8%80%E4%B8%AAexcelk%E4%B8%AD%EF%BC%88%E6%95%B0%E6%8D%AE%E5%BA%93%EF%BC%89%E6%9C%89%E4%B8%80%E4%B8%8B%E5%88%97%E5%85%AC%E5%BC%8F%2C%E4%BD%86%E5%A4%AA%E5%A4%8D%E6%9D%82%E4%BA%86%2C%E7%9C%8B%E4%B8%8D%E6%87%82%2C%E6%9C%89%E5%93%AA%E4%BD%8D%E9%AB%98%E6%89%8B%E8%A7%A3%E8%AF%B4%E4%B8%8B%2C%E6%AD%A4%E5%85%AC%E5%BC%8F%E8%A1%A8%E7%A4%BA%E4%BD%95%E6%84%8F%E6%80%9D%3F%3DIF%28OR%28%24H3%3D%22%22%2CC3%3D%22%22%29%2C%22%22%2CIF%28VLOOKUP%28%24H3%2C%E6%95%B0%E6%8D%AE%E5%BA%93%21%24A%242%3A%24S%2410000%2CMATCH%28F%242%2C%E6%95%B0%E6%8D%AE%E5%BA%93%21%24A%24)
xU[OA+Jxd"71DMmM_[cFSIM>()4(^XDD\.gvy/̺Mch YfΜfypU Xz\;ԲZZJ.ǩyC*陹Yz|]qAI^#4Q,Dm [lf"Z:Vc4 ɢڈi$3KqƚQploiXģO1ZIӁy<nGx^V