Compare two values based on condition

[srizki]

I trying to compare values in column A and column B, to see if the numbers are same, the formula =A=B will not work because there may me few cents difference, therefore I need a formula that compares the two values based on criteria, for example I am comparing values in two column say $4568.52 and 4569.22, so the formula says that is fine due to criteria that if the difference is less than say one dollar or $50, it is considered OK.

 

[Aladin Akyurek]

=(ABS(A2-B2)<=50)+0

1 ==> OK; 0 ==> Not OK.

 

[orbea_adam]

Book1
	A	B	C	D
1			Difference
2	4568.52	4569.22	OK
Sheet1

 

[srizki]

Thank you Aladin and Orbea,
I appreciate your help.