求在excel中怎么用函数来算这个公式女性:SCr≤62μmol/L (≤0.7mg/dL):GFR = 144 × (Scr/0.7)-0.329× (0.993)AgeSCr>62μmol/L (>0.7mg/dL):GFR = 144 × (Scr/0.7)-1.209 × (0.993)Age男性:SCr≤80μmol/L (≤0.9mg/dL):GFR = 141
来源:学生作业帮助网 编辑:作业帮 时间:2024/08/02 20:39:22
![求在excel中怎么用函数来算这个公式女性:SCr≤62μmol/L (≤0.7mg/dL):GFR = 144 × (Scr/0.7)-0.329× (0.993)AgeSCr>62μmol/L (>0.7mg/dL):GFR = 144 × (Scr/0.7)-1.209 × (0.993)Age男性:SCr≤80μmol/L (≤0.9mg/dL):GFR = 141](/uploads/image/z/209644-52-4.jpg?t=%E6%B1%82%E5%9C%A8excel%E4%B8%AD%E6%80%8E%E4%B9%88%E7%94%A8%E5%87%BD%E6%95%B0%E6%9D%A5%E7%AE%97%E8%BF%99%E4%B8%AA%E5%85%AC%E5%BC%8F%E5%A5%B3%E6%80%A7%EF%BC%9ASCr%E2%89%A462%CE%BCmol%2FL+%28%E2%89%A40.7mg%2FdL%29%EF%BC%9AGFR+%3D+144+%C3%97+%28Scr%2F0.7%29-0.329%C3%97+%280.993%29AgeSCr%3E62%CE%BCmol%2FL+%28%3E0.7mg%2FdL%29%EF%BC%9AGFR+%3D+144+%C3%97+%28Scr%2F0.7%29-1.209+%C3%97+%280.993%29Age%E7%94%B7%E6%80%A7%EF%BC%9ASCr%E2%89%A480%CE%BCmol%2FL+%28%E2%89%A40.9mg%2FdL%29%EF%BC%9AGFR+%3D+141)
求在excel中怎么用函数来算这个公式女性:SCr≤62μmol/L (≤0.7mg/dL):GFR = 144 × (Scr/0.7)-0.329× (0.993)AgeSCr>62μmol/L (>0.7mg/dL):GFR = 144 × (Scr/0.7)-1.209 × (0.993)Age男性:SCr≤80μmol/L (≤0.9mg/dL):GFR = 141
求在excel中怎么用函数来算这个公式
女性:SCr≤62μmol/L (≤0.7mg/dL):GFR = 144 × (Scr/0.7)-0.329× (0.993)Age
SCr>62μmol/L (>0.7mg/dL):GFR = 144 × (Scr/0.7)-1.209 × (0.993)Age
男性:SCr≤80μmol/L (≤0.9mg/dL):GFR = 141 × (Scr/0.9)-0.411 × (0.993)Age
SCr>80μmol/L (>0.9mg/dL):GFR = 141 × (Scr/0.9)-1.209 × (0.993)Age
其中SCR可以为另一列具体数值,age为年龄,我自己列了一个算法,
=IF(D3="女",144*(B3/0.7)^(-0.329)*0.993^C3,IF(B3>62,144*(B3/0.7)^(-1.209)*(0.993)^(C3),IF(D3="男",141*(B3/0.9)^(-0.411)*(0.993)^(C3),(IF(B3>80,141*(B3/0.9)^(-1.209)*(0.993)^(C3))))))
其中D列为性别项,B列为SCR,C列为年龄,但是计算后发现男性的计算结果不正确,请大神帮我看下,或者用其他函数能行的
求在excel中怎么用函数来算这个公式女性:SCr≤62μmol/L (≤0.7mg/dL):GFR = 144 × (Scr/0.7)-0.329× (0.993)AgeSCr>62μmol/L (>0.7mg/dL):GFR = 144 × (Scr/0.7)-1.209 × (0.993)Age男性:SCr≤80μmol/L (≤0.9mg/dL):GFR = 141
=IF(D3="女",144*(B3/0.7)^IF(B3<=62,-0.329,-1.209)*0.993^C3,141*(B3/0.9)^IF(B3<=80,-0.411,-1.209)*(0.993)^(C3))
看上去SCr的单位是用mg/dL而不是μmol/L,所以B3的值要转换下,具体的不清楚,只是就公式论公式.