CKD Epi Formula in an excel formula

[joecooper98]

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 Formula

Any help is highly appreciated, thank you in advance 

[#2]

@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.

[#3]

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 ?

[#4]

@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?

[#5]

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 !

[#6 · Accepted 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))

[#7]

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

[#8]

@joecooper98 

For those that can't get it to work in their version of Excel, replace the semicolons with commas :) Fixed equation is below with same variables

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)^-0.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))