Problem with a formula

[Princessboko]

I'm trying to write a formula to calculate dosages of a medicine.
What I have is C3 is the weight of a patient in kg. So

IF C3<=50,50
IF C3>=117,117
IF C3>50 or <117 (a number between 51-116)
* 16 for the drip of the IV

My formula is:
=IF(C3<=50,50)+OR(C3>117,117)+OR(C3>50)+OR(C3<117)*16

Then in I3 the result of the above is divided by 50 for my result.

What am I doing wrong?

Thank you!

 

[Barry Katcher]

Here's your formula. I did it without the "times 16" so you could easily see the results of the different weights. Just add *16 to the end of the formula.

New Book.xls
	B	C	D	E	F
2
3		40		50
4		49		50
5		50		50
6		55		55
7		68		68
8		116		116
9		117		117
10		130		117
11		150		117
12
Sheet3

 

[Joe4]

I am not sure of your second condition, if it is the number in C3 times 16, but if it is, here is a formula:

=IF(C3>117,117,IF(C3>50,C3*16,50))

 

[Damon Ostrander]

Hi princess,

I believe

=MIN(MAX(C3,50),117)*16

Accomplishes the same thing.

 

[just_jon]

I'm trying to write a formula to calculate dosages of a medicine.
What I have is C3 is the weight of a patient in kg. So

IF C3<=50,50
IF C3>=117,117
IF C3>50 or <117 (a number between 51-116)
* 16 for the drip of the IV

My formula is:
=IF(C3<=50,50)+OR(C3>117,117)+OR(C3>50)+OR(C3<117)*16

Then in I3 the result of the above is divided by 50 for my result.

What am I doing wrong?

Thank you!

Maybe --
=IF(C3>=117,117,IF(C3<=50,50,(C3*16)/50))

Although if 50 gets 50, it looks odd that 51 would get [51*16=816/50=16.32]... Am I missing something?

 

[Barry Katcher]

Nice formula, Damon. :idea:

 

[Princessboko]

Thanks a million.

The final result is based on a fraction of a mL/hr so if it is 51 it is based on a fraction of the mL.

Thanks again!