SOLVED

Contributor

# Identify a mismatch based on a range

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
best response confirmed by shade206 (Contributor)
Solution

# Re: Identify a mismatch based on a range

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