Results 1 to 4 of 4

Thread: If function help

  1. #1

    If function help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello everyone,
    I need help with if function:
    I have 5 values ( 5 different cells )in one row;in next empty cell I want to put formula if where I want to see: if a2=b2=c2=d2=e2 to put true or false, I can't get this.

    Thank you so much In advance!

  2. #2
    Hello
    use=IF(AND(A2=B2,A2=C2,A2=D2,A2=E2),TRUE,FALSE)

  3. #3
    Thank you

  4. #4
    Acolyte Ron Coderre's Avatar
    Join Date
    Aug 2015
    Location
    Boston, MA
    Posts
    93
    Articles
    0
    Excel Version
    2013, 2016, O365
    Seems like this would work:
    =COUNTIF(A2:E2,A2)=5

    Does it?
    Ron Coderre
    Former Microsoft MVP (2006-2015)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •