Thread: set logical test to see if 4 cells have same value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default set logical test to see if 4 cells have same value
=countif(A1:B2,A1)=4

--
Regards,
Tom Ogilvy


"ChrisMohler" wrote:

I am trying to write a formula in Excel that tells whether 4 cells in the
same row have the same value. The IF function is limited to 2 cells.
Reply With QuoteReply With Quote