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