your formula looks OK and should provide you with the result you are
seeking.
Is your calculate option set to Automatic and not Manual?
"clane" wrote in
message ...
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
--
clane
------------------------------------------------------------------------
clane's Profile:
http://www.excelforum.com/member.php...o&userid=11865
View this thread: http://www.excelforum.com/showthread...hreadid=381265