srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,844
- Office Version
- 365
- Platform
- Windows
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.