How to use if with multiple conditions

Hello

I am trying to use if formula to satisfy 3 conditions, for example:

this is my formula:

=IF(K8>=1.2,E12),IF((I7<=K6),E13),IF(AND(K8<1.2,I7>K6),E11)

I am trying to select e12 if K8>=1.2 and select E13 if I7<=K6 and to select E11 if the first 2 conditions are false. Anyone have any suggestions?

RB

That gave me E12 if K8>=1.2 and E11 if K8<1.2 and I7>K6

but it did not give me E13 for I7<=K6



RB

I am trying to make a calculator for renal function.

Ideal Body Weight (K6)
Actual Body Weight (I7)
ABW/IBW Ratio (K8)

Creatinine Clearance (IBW): (E11)
Creatinine Clearance (ABW*): (E12)
Creatinine Clearance (Actual): (E13)

I would like E12 to be selected if ABW/IBW Ratio >=1.2 (K8)
I would like E13 to be selected if Actual Boday Weight (I7) < IBW (K6)
I would like E11 to be selected if the above 2 conditions are not met.

Thanks so much for your help.

RB

Try

=IF(AND(K8<1.2,I7>=K6),E11,IF(K8>=1.2,E12,IF(I7<K6,E13,"")))

Thanks for your help guys! That worked!

RB

You're welcome. Please remember to mark your thread as SOLVED (instructions are in rule #9 - click Forum Rules @ top of page to view).