View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ChrisPrather ChrisPrather is offline
external usenet poster
 
Posts: 1
Default 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