you怎么算excel表格

1.如何把下面的表格变成EXCEL公式,求C=?

假定，例图为sheet2表，A变量位于A列，B变量位于第一行B1:E2区间；当前工作表为sheet1，待查A变量位于A2，待查B变量位于B2，待查结果C位于C2；建议：

1、将A、B变量标题作一简化修改：

A3:A8为0、1、2、3、4、5;

B1 为0.01;C1为0.02;D1为0.03;1

2、C2公式为：

=INDEX(Sheet2!$B$3:$E$8,MATCH(LOOKUP($A2,{0,1,2,3,4},{1,2,3,4,5}),Sheet2!$A$3:$A$8,0),MATCH(LOOKUP($B2,{0,0.01,0.02,0.03},{0.01,0.02,0.03,1}),Sheet2!B$1:E$1,0),1)

式中：

Sheet2!$B$3:$E$8 待查询返回C的数据区域；

MATCH(LOOKUP($A2,{0,1,2,3,4},{1,2,3,4,5}),Sheet2!$A$3:$A$8,0） 查询A变量行位置；

其中：LOOKUP($B2,{0,0.01,0.02,0.03},{0.01,0.02,0.03,1})，处理变量数据，转换为可查询数值；

MATCH(LOOKUP($B2,{0,0.01,0.02,0.03},{0.01,0.02,0.03,1}),Sheet2!B$1:E$1,0） 查询B变量列位置；

此公式和方法可适用于wps表格/excel，已验证。

更多WPS办公软件教程，请访问：/wpswfw

2.Excel 怎样计square

Please make clear first. If you want to add an "FORMULA", The "X" is never appeared in the formula. It will be ted into X. Therefore. (2*2)X 3 is not possible to apear in the excel bar. It will automatically ted to (2*2)* 3"= 22 x 3" can>2*2)X 3 can be =2^2*3Make one more example:(2 x 2 x 2 x 2 x 2) x 3 can be written as =2^5*3Hope I can help。