IF函数公式求解B1=25,22,18,16,14,12,10,8,6时,对应的I1=I1*3.85,2.98,2.47,2,1.58,1.21,0.888,0.617,0.395,0.261.这个函数怎么写啊?~~求大神帮忙啊
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/05 19:41:04
![IF函数公式求解B1=25,22,18,16,14,12,10,8,6时,对应的I1=I1*3.85,2.98,2.47,2,1.58,1.21,0.888,0.617,0.395,0.261.这个函数怎么写啊?~~求大神帮忙啊](/uploads/image/z/10277297-17-7.jpg?t=IF%E5%87%BD%E6%95%B0%E5%85%AC%E5%BC%8F%E6%B1%82%E8%A7%A3B1%3D25%2C22%2C18%2C16%2C14%2C12%2C10%2C8%2C6%E6%97%B6%2C%E5%AF%B9%E5%BA%94%E7%9A%84I1%3DI1%2A3.85%2C2.98%2C2.47%2C2%2C1.58%2C1.21%2C0.888%2C0.617%2C0.395%2C0.261.%E8%BF%99%E4%B8%AA%E5%87%BD%E6%95%B0%E6%80%8E%E4%B9%88%E5%86%99%E5%95%8A%3F%7E%7E%E6%B1%82%E5%A4%A7%E7%A5%9E%E5%B8%AE%E5%BF%99%E5%95%8A)
IF函数公式求解B1=25,22,18,16,14,12,10,8,6时,对应的I1=I1*3.85,2.98,2.47,2,1.58,1.21,0.888,0.617,0.395,0.261.这个函数怎么写啊?~~求大神帮忙啊
IF函数公式求解
B1=25,22,18,16,14,12,10,8,6时,对应的I1=I1*3.85,2.98,2.47,2,1.58,1.21,0.888,0.617,0.395,0.261.
这个函数怎么写啊?~~求大神帮忙啊
IF函数公式求解B1=25,22,18,16,14,12,10,8,6时,对应的I1=I1*3.85,2.98,2.47,2,1.58,1.21,0.888,0.617,0.395,0.261.这个函数怎么写啊?~~求大神帮忙啊
=HLOOKUP(B1,{25,22,18,16,14,12,10,8,6;3.85,2.98,2.47,2,1.58,1.21,0.888,10,20},2,0)*I1
注意
;分号前面9个数字,分别对应后面9个数字