I am looking to create a formula to help me determine if a dose of a medication is appropriate based on a few variables. the columns I have are the following:
J2=creatinine clearance
L2=type of renal replacement therapy (has three possible values: IHD, SLED, or CRRT)
M2=dose (has two possible values: 2.25 or 3.375)
Based on the criteria the dose is appropriate in the following situations:
J2>20 OR L2=CRRT AND M2 = 3.375,
J2<20 OR L2=IHD OR L2 = SLED AND M2=2.25.
This is the formula I have so far:
=IF(AND(OR(J2>20,L2="CRRT"),(M2=3.375)),"YES",IF(AND(OR(J2<20,L2="IHD",L2="SLED"),(M2=2.25)),"YES","NO"))
It seems to be working except when J2>20,L2=IHD and M2=3.375 the output is that the dose is appropriate when it shouldn't be, as if L2=IHD M2 has to equal 2.25 for the dose to be appropriate. Would greatly appreciate any help or advice!
Bookmarks