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...
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
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