Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF logic only works 7 times
Hello, I have the following IF function that works great on the first seven rows. Starting with row 8, every row until the end of the column evalautes to false and outputs the false statement incorrectly on the sheet. Please help by telling me what I am doing wrong or may not understand. Thank you in advance. =IF(A1=Sheet2!A:A,"True","False") -- ChrisPrather ------------------------------------------------------------------------ ChrisPrather's Profile: http://www.excelforum.com/member.php...o&userid=37743 View this thread: http://www.excelforum.com/showthread...hreadid=573274 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
works document trying to read in excel | New Users to Excel | |||
How to inport works spreadsheet into excel 2007 | Excel Worksheet Functions | |||
sorting multiple minimum times | Excel Discussion (Misc queries) | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) |