Forum Discussion
Koli
2 years agoFrequent Visitor
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 Amount
$130.00 $129.99998
Essentially these are the same numbers with rounding
I would like the conditional formatting to read .. if sum of amount is almost the sum of the 2nd amt then place remark, else null.
I know that's not the correct operator. However this is what I'm trying to get to. Is this possible?
Thank you!
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!