Forum Discussion
CKD Epi Formula in an excel formula
- 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))
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.
hi thank you for your offert may i have this formal but with umol/L and change 0 to male and 1 to female cux i have a big study for GFR and really need this formal as this site result.
https://www.mdcalc.com/calc/3939/ckd-epi-equations-glomerular-filtration-rate-gfr#evidence
as an excel sheet thank you
