| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function comare to identical amount but inconsistent results
I tried to compare the amount of 2 colums (10 rows) because and ithey are the same amount extracted from 2 different sources. Here is my function =IF(B7=E7,TRUE,False) Some rows came out to be True, however, I get some "False" results and when I eye-balled the two amounts, they are identical. So I am not sure why two identical amounts would give me "false" results. I tried to format both columns to 2 decimal places and it still doesn't work. Can someone please tell me how to fix this problem? Thanks so much. -- skhuon ------------------------------------------------------------------------ skhuon's Profile: http://www.excelforum.com/member.php...o&userid=36902 View this thread: http://www.excelforum.com/showthread...hreadid=566176 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Function results be calculated? | New Users to Excel | |||
| abdualmohsn | Excel Discussion (Misc queries) | |||
| Function Formula is displayed not results | Excel Worksheet Functions | |||
| in excel how to display results of a function and text in the sam. | Excel Worksheet Functions | |||
| IF function displays wrong amount | Excel Worksheet Functions | |||
Threaded Mode
