Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding Values With more than 2 decimal Places
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
decimal places within a formula | Excel Discussion (Misc queries) | |||
DECIMAL PLACES IN FORMULAS | Excel Worksheet Functions | |||
Changing default decimal places | Excel Discussion (Misc queries) | |||
goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) | |||
Entering numbers with variable decimal places. | Excel Worksheet Functions |