Hello,

I am using sumif to verify some numbers. These should all be dollar values and thus should not contain and values past 2 decimal places however when I use the sumif it returns values with long decimals? I have been unable to find where these decimals exist visually and i tried this formula to help me identify them

=IF(L18-(ROUND(L18,2))=0,0,"Help")
^ hopefully this would let me know if a decimal past 2 places is present in a value but I still am unable to find them?


any help would be apreciated


Thanks

Chuck