Doesn't subtract right.

[wkirkcrawford]

Greetings,

I keep a Diabetic Log, and I want to compare this period to the last period.

The code that I use is,;
="I'm " & (ABS(INT(I17-'April 2020 - July 2020'!I14) ) ) & " points, " & IF(I17>'April 2020 - July 2020'!I14,"Higher", "Lower")&" than the last peroid. "

The difference will range from 1 to 3 units.

Any ideas?

W. Kirk Crawford
Tularosa, New Mexico

 

[Fluff]

What's in I14 on the April sheet?

 

[wkirkcrawford]

Fluff,

=AVERAGE(K20:K312,P20:P312,V20:V312,AA20:AA312,AI20:AI312,AM20:AM312,AS20:AS312,AU20:AU312,AQ20:AQ312)

At the end of a time of that period was 171.

W. Kirk Crawford
Tularosa, New Mexico

 

[Fluff]

Is that in I14 or I16?
I would expect I14 to be using MAX, judging by your labels.

 

[wkirkcrawford]

Fluff,

No, I'm not looking for the MAX, but the Average. Maybe I should be looking at the Mediam.

There was a time when my High was over 400. Then I took it again and it was within 300 something.

I think that I use the wrong worksheet. It should have been,
="I'm " & (ABS(INT(I16-'July 2020 - Nov 2020'!I17) ) ) & " points, " & IF(I16>'July 2020 - Nov 2020'!I17,"Higher", "Lower")&" than the last peroid. "

W. Kirk Crawford
Tularosa, New Mexico

 

[Fluff]

You still seem to be comparing different values, Median on one sheet & Average on the other. Shouldn't you be comparing the same values?

 

[wkirkcrawford]

Fluff,

I'm sorry if it seems that way, but the rows change from one period to the next period.

Today the Average is 156. Last period it was 171,

Wl Kirk Crawford
Tularosa, New Mexico

 

[Fluff]

In that case your formula seems to be working as it's giving a value of 15.

 

[wkirkcrawford]

Fluff

Thank you so very much for your time.

W. Kirk Crawford
Tularosa, New Mexico

 

[Fluff]

You're welcome & thanks for the feedback.