Forum Discussion
Solved
CKD Epi Formula in an excel formula
Hello, does anyone have the formula to calculate CKD EPI which reflects the renal function in medicine in one excel formula, the CKD EPI formula being : Any help is highly appreciate...
- B1 = Scr
B2 = 0 for male, 1 for female
B3 = Age
=IF(B2=0;IF(B1>0.9;142*(B1/0.9)^-1.2*0.9938^B3;142*(B1/0.9)^-.302*0.9938^B3);IF(B1>0.7;142*(B1/0.7)^-1.2*0.9938^B3*1.012;142*(B1/0.7)^-0.241*0.9938^B3*1.012))
With gender (Male or Female) in B2, Age (in years) in C2, and Scr in E2:
=142*(D2/IF(D2<=0.7,0.7,0.9))^IF(B2="Female",-1.2,IF(D2<=0.7,-0.241,-0.302))*0.9938^C2*IF(B2="Female",1.012,1)
See the attached workbook.
HansVogelaar I tried my data on that Excel but it gives wrong results...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
For example, I used your Excel file EPI. Column E has the values according to your formula. Column F has the real values manually calculated according to CKD-EPI 2021 equation.
The one who started this discussion, joecooper98, posted a corrected formula (marked as the solution). I have adjusted it for the layout of the sample workbook.