Forum Discussion
Solved
Reconciling 2 Data Sets
Hello, I hope all is well. I am trying to reconcile 2 different data sets. One of the problems I am running to is rounding and conditional formatting. For example: Sum of Amount 2nd Am...
Hello,
Thank you for responding. I was able to figure it out. I used conditional formatting,
if AF variance is less than or equal to zero then rounding.
Thank you!
- There not an exact match, but almost an exact match
| Sum of Fee.1 | Sum of Fee.2 | AF Variance | Rounding | Remarks should say |
| 135.41 | 135.412 | -0.002 | 0.00 | Rounding |
| 430.59 | 430.5862 | 0.0038 | 0.00 | Rounding |
| 135.41 | 135.412 | -0.002 | 0.00 | Rounding |
| 430.59 | 430.5862 | 0.0038 | 0.00 | Rounding |
| 135.41 | 135.41 | 0 | 0.00 | Rounding |
| 430.59 | 430.5862 | 0.0038 | 0.00 | Rounding |
all of your sample data is "almost" a match, and it seems to be based on two decimals.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Hello,
Thank you for responding. I was able to figure it out. I used conditional formatting,
if AF variance is less than or equal to zero then rounding.
Thank you!