All in one Cell?

[wkirkcrawford]

Greetings,

I have a Diabetic Blood Sugar Log, and I want to show how much higher or below I am than last the period.

I want it to say, I'm 26 points Higher than the last period.

I know that the number, 26, is one cell - another cell on another worksheet. And the Higher or Below is IF cell 1 is > cell 2, Higher, Below? That's what I'm thinking.

W. Kirk Crawford
Tularosa, New Mexico

 

[etaf]

whats a period

lets say the OLD value is in A2 and the new value in A3
you could put in B3

IF ( A3 > A2, "Higher", "Below or same")

Book4
	A	B
2	2
3	1	Same or lower
4	2	higher
5	1	Same or lower
6	3	higher
7	1	Same or lower
8	3	higher
9	4	higher
10	4	Same or lower
11	4	Same or lower
12	2	Same or lower
13	1	Same or lower
Sheet1

Cell Formulas
Range	Formula
B3:B13	B3	=IF(A3="","",IF(A3>A2,"higher","Same or lower"))

 

[wkirkcrawford]

Greetings,

I have this working. =IF(I14-'Oct 2019 - April 2020'!I14,"Higher", "Lower")

Now if I could put in from of that, "I'm ## points, =IF(I14-'Oct 2019 - April 2020'!I14,"Higher", "Lower")

 

[etaf]

="I'm ## points, " & IF(I14-'Oct 2019 - April 2020'!I14,"Higher", "Lower")

what cell are the calcs in , i dont see a >

="I'm " & I14-'Oct 2019 - April 2020'!I14 & " points, " & IF(I14-'Oct 2019 - April 2020'!I14,"Higher", "Lower")

 

[wkirkcrawford]

="I'm ## points, " & IF(I14-'Oct 2019 - April 2020'!I14,"Higher", "Lower")

what cell are the calcs in , i dont see a >

="I'm " & I14-'Oct 2019 - April 2020'!I14 & " points, " & IF(I14-'Oct 2019 - April 2020'!I14,"Higher", "Lower")

etaf,

That works great. Thanks.

Now what IF, I14-'Oct 2019 is not Higher than April 2020'!I14?

W. Kirk Crawford
Tularosa, New Mexico

 

[etaf]

you need the > , but looking at the formula comparing last period to new needs <
IF(I14-'Oct 2019 - April 2020'!I14,"Higher", "Lower")
in the if
I14-'Oct 2019 - April 2020'!I14
gives a number
0 is FALSE anything is TRUE
so
="I'm " & abs(I14-'Oct 2019 - April 2020'!I14) & " points, " & IF(I14-'Oct 2019 < April 2020'!I14,"Higher", "Lower")
abs removes the sign for negative numbers

 

[wkirkcrawford]

etaf,

Now I get #REF! as a result.

I think I'm getting somewhere.

W. Kirk Crawford
Tularosa, New Mexico

 

[etaf]

="I'm " & ABS(I14-'Oct 2019 - April 2020'!I14) & " points, " & IF(I14>'Oct 2019 - April 2020'!I14,"Higher", "Lower")

 

[wkirkcrawford]

Wayne,

Thanks, that's the answer. It works.

This Forum is the answer.

W. Kirk Crawford
Tularosa, New Mexico

 

[etaf]

you are welcome