How to write a drug accountability formula?

[orlandomedic]

I work in clinical research and would like a program to calculate a patient's medication compliance between visits and to share with the whole team. This would make a lot of people happy and it's something we can print and place in the chart.
Formula
Calculate the percentage difference between two numbers(Total dispensed - returned) / (Days between visits x dose[# of pills])
Example:
(200-120) / (31 x 3) = 80 / 93 = 0.86 x 100 = 86%
Any help would be greatly appreciated!!

 

[shg]

Looks like you've got it sorted -- what's your question?

 

[orlandomedic]

Hi,
How would I wite this formula in a language to use in excel ?
Thank you!

 

[shg]

	A​	B​	C​	D​	E​	F​	G​
1​	Visit​	Dispensed​	Dose​	Visit​	Returned​	Compliance​	​
2​	1 Jan 2018​	200​	3​	1 Feb 2018​	120​	86%​	F2: =(B2 - E2) / ((D2 - A2) * C2)

 

[orlandomedic]

Thank you very much!!I am going to try this right away!

 

[shg]

Y'er welcome.