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))
To my mind, this is an application that is absolutely crying out for an Excel 365 Lambda function!
CKD.Epi
= LAMBDA(Scr, age, [isFemale],
LET(
A, IF(isFemale, 0.7, 0.9),
B, IF(Src/A <= 1, IF(isFemale, -0.241, -0.302), -1.2),
142 * (Src/A)^B * 0.9938^age * 1.012^isFemale
)
)The worksheet formula (one for the entire table) is then
= CKD.Epi(Src, Age, Gender="Female")
The image didn't come through?