Calculate Increase/Decrease

[KatJones1234]

Hi,
I’m stuck. I need to calculate whether waist circumference has increased, decreased or remained stable (while ignoring if any cell is blank)
I can’t get the IFs formula to work.
I got it to do the increase and decrease, but can’t get the stable. When I tried to modify the formula to be IFs I get the #name? Error
This is what I got
=IF(ISBLANK(A1),””,IF(ISBLANK(B1),””,IF(A1>B1,”Decrease”,”Increase”)))

 

[jtakw]

Hi,

If you get the #NAME error when trying to use IFS, that means you don't have that function (available with an Office 365 subscription), but is this what you need:

Book1
	A	B	C
1	34	36	Increase
2	36	35	Decrease
3	38	38	Stable
Sheet554

Cell Formulas
Range	Formula
C1	=IF(OR(A1="",B1=""),"",IF(A1>B1,"Decrease",IF(A1)))

 

[KatJones1234]

Thank you so much! It works! You’re amazing

 

[jtakw]

You're welcome, welcome to the forum.