Forum Discussion
Solved
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 |
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
1 Reply
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