• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Comparison

N

niting

New Member
HI forum,


Is there a way to use countif for comparison purposes as explained in chandoo's post of comparison ninza, where the two columns contain amounts but with minor changes due to rounding off. eg one column contains 819 and other column contains 819.6.


Thanks

Niting
 
What about Conditional formatting

Assuming Columns A @ B

Try a Conditional format formula like

=ABS(A2-B2)<1.0
 
You must log in or register to reply here.
Back
Top