I'm trying to save time and make a formula on excel and I'm not sure how...

I have a column which is AL2 that contains a number between 0 and 120 (estimated glomerular filtration rate) in cc/min

I want to stratify the EGFr according to the renal insufficiency stage in another column based on this:

Stage 2: 60 to 89
Stage 3A: 45 to 59
Stage 3B: 30 to 44
Stage 4: 15 to 29
Stage 5: < 15

Edit: if its >/= 90, I just want the formula to give nothing as a result

So this new column would give me the chronic renal insufficiency stage based on the eGFR

Thanks in advance

This post was edited by DOHtrader on Apr 4 2023 11:56am

I have absolutely NO idea what this all means, but i've been messing with ChatGPT for other reasons the past few weeks, tried asking that?

I just pasted everything you said into it, and this is what i got.

=IF(AL2>=90,"",IF(AL2>=60,"Stage 2",IF(AL2>=45,"Stage 3A",IF(AL2>=30,"Stage 3B",IF(AL2>=15,"Stage 4","Stage 5")))))

LMK if it actually worked, or if that's what you're looking for. Lol



This post was edited by Bracko on Apr 4 2023 12:02pm

It it close to what I am looking for, but yours doesnt work. It really needs to take into account that stages are intervals (e.i "15 to 29")

This post was edited by DOHtrader on Apr 4 2023 12:12pm

Was worth a shot! Maybe you should try to mess with ChatGPT yourself? i'm almost sure that it'll have your answers if you just express it the right way.