Comparing 4 cells of data to return yes or no value if match within 1-2 numbers of each other

[JayeGSP]

comparing this row for example: 29 29.5 29.5 29.75
I figured out the formula to compare them and return YES or NO if they match but can't figure out how to add something so it will return a yes value if 29.5, 29.75 or 30.

 

[Eric W]

Welcome to the MrExcel forum!

Try:

Book1
	A	B	C	D
1
2	29		no	Yes
3	29.5
4	29.5
5	29.75
6
Sheet8

Cell Formulas
Range	Formula
C2	C2	=IF(A2=A3,"yes","no")
D2	D2	=IF(ABS(A2-A3)<1,"Yes","no")

Change the "1" value (sometimes called a tolerance) to how close you want the values to be when compared.

 

[Peter_SSs]

Welcome to the MrExcel board!

.. or could it be something like this that you are after?

24 08 13.xlsm
	A	B	C
1
2	29		Yes
3	29.5
4	29.5
5	29.75
Close

Cell Formulas
Range	Formula
C2	C2	=IF(MAX(A2:A5)-MIN(A2:A5)<=1,"Yes","No")