第1个回答 2020-04-17
z
=(((R9*U10)-(R10*U9))*((R10*S11)-(R11*S10))-(((R10*U11)-(R11*U10))*((R9*S10)-(R10*S9))))/(((R9*T10)-(R10*T9))*((R10*S11)-(R11*S10))-(((R10*T11)-(R11*T10))*((R9*S10)-(R10*S9))))
y
=(((R9*U10)-(R10*U9))*((R10*T11)-(R11*T10))-(((R10*U11)-(R11*U10))*((R9*T10)-(R10*T9))))/(((R9*S10)-(R10*S9))*((R10*T11)-(R11*T10))-(((R10*S11)-(R11*S10))*((R9*T10)-(R10*T9))))
x
=(((S9*U10-S10*U9)-(S9*T10-S10*T9)*R14)/(S9*R10-R9*S10))
范围在R9~U11,一个3x4的长方形,从左往右分别是a,b,c,d,上往下分别是1,2,3。用XLSX文档,只不过有些求不出来(是BUG,我也很无奈。)。