Analyze % moving in right direction?

[pinot]

The heartrate of patients were measured at two different times. The healthy range let's say is 60-90, and some patients started with values higher, some started with lower ones. How / with which formula do I analyze how many percent of the patients have moved in a right (or wrong) direction (improve or worsened), given the healthy range?

 

[etaf]

i'm assuming in the range does not count ?
Or does it ?
so the mean is 75

if the reading was 88 and moved to 80 - is that in the right direction OR does not count
or if say 70 and now 85 is that moving in wrong direction ?

or does the mean of 75 not matter and you use a different figure ?

 

[pinot]

Yeah, all moves within the range 60-90 don't count. A move from inside the range 60-90 to outside counts as in wrong direction, and a move from outside the range toward or into the range counts as right direction.

 

[etaf]

this is a bit messy as I'm sure it can be done without a lot of nested IF 's
anyway

=IF(AND(AND(C6 < = 90, C6 > = 60),AND(D6 < = 90, D6 > = 60)),"Normal",IF(C6-D6 < 0,"Pos",IF(C6-D6 > 0,"Neg","Zero")))

But i guess you also want to see if moved into normal range NOT just the change

so we could test the 2nd result and if normal - include that in the Normal group

C6 = the 1st test
D6 = the 2nd test

Change cells to suite your spreadsheet cells used