Identify a mismatch based on a range

[shade206]

Hello,

I have the below data of prices. There are prices in which there is an insignificant difference i.e. 1 penny. I need a formula to identify prices that there is a significant difference say by more than a full dollar and insignificant ones i.e. anything less than a dollar. and present it as is below.   

A	B	C
Vendor 1	Vendor 2	Difference
1236.83	1199.72	Significant
1562.31	1359.26	Significant
1669.45	1669.44	Significant
1842.72	1789.1	Significant
1707.92	1656.67	Significant
1046.65	1046.64	Insignificant
1533.43	1489.1	Significant
2153.16	2090.25	Significant
1866.01	1866	Insignificant
2211.15	2211.14	Insignificant
2220.81	2220.8	Insignificant
2028.01	1968.85	Significant
2943.48	2547.07	Significant
3441.75	2959.89	Significant
2366.53	2050.9	Significant
2769.74	2688.32	Significant
3789.59	3789.58	Insignificant

[#2 · Accepted solution]

Hi @shade206 

You can use this formula:

=IF(A2-B2<1,"inSignificant", "Significant")

<1 mean the difference between the two prices is less than 1 , so you can change the number that fits your needs