Thread: Excel IF formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default Excel IF formula
=IF(AND(A2=A1,B2=B1),TRUE,FALSE)

I think the IF part of the formula can be eliminated completely...

=AND(A2=A1,B2=B1)

Rick
Reply With QuoteReply With Quote