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))
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
