SOLVED

CKD Epi Formula in an excel formula

Occasional Contributor

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 : 

 

CKD EPI FormulaCKD EPI Formula

 

 

Any help is highly appreciated, thank you in advance 

6 Replies

@joecooper98 

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.

Thank you for your reply, I really appreciate your help
However, I got the formula from :
https://www.mdcalc.com/ckd-epi-equations-glomerular-filtration-rate-gfr#evidence
And I tried to compare the excel values and the values from the website.
B C F G match in values however the rest of the options seem to have different values
Do you know what might be the reason ?

@joecooper98 

The formula discriminates between Scr<=0.7 and Scr<=0.9, but does not specify what to use if Scr>0.9.

The website states that normal values for Scr are 62-115, and does not accept values below 0.89.

What gives?

Yes Hans, thank your for your reply, actually the values 62-115 refer to the normal serum creatinine in umol/L, however if you click on the parallel green arrows, the normal value shows between 0.7 and 1.3, these values are in mg/dL. And I think the Scr values in the equation are in mg/dL too.
Furthermore, in the table, if I am not mistaken, if Scr > 0.9 A = 0.9 B = -1.2

I hope this reply answers your questions,
Thank you for your help Hans,
If you need anything else, don't hesitate to reach out !

best response confirmed by joecooper98 (Occasional Contributor)
Solution
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))
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))

This solution worked best for me, thank you Hans