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))
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")
thank you for your respond but dose not work for me anymore
for me i want only to change the unit for umol/l , for gender i can fix it later
I am sorry the solution did not work out for you. Do you use Excel 365; that is essential.
I am absolutely convinced, however, that the Lambda function offers the only sensible way forward in the longer term.
Thank you also for the link; it is good to improve my education even now. I had rather assumed it was a linear regression model but it was good to be able to confirm it.
thank you for your kind respond
yes im using 365 Excel
could you find me i way cuz i need it for my big study?
thank you
The image didn't come through?
