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