+ Reply to Thread
Results 1 to 2 of 2

How to simplify this formula

  1. #1
    Registered User
    Join Date
    06-15-2011
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question How to simplify this formula

    =IF(AND(B52=1, A52 <> A5, A52 <> A11, A52 <> A17), A52, IF(AND(B53=1, A53 <> A5, A53 <> A11, A53 <> A17), A53, IF(AND(B54=1, A54 <> A5, A54 <> A11, A54 <> A17), A54, IF(AND(B55=1, A55 <> A5, A55 <> A11, A55 <> A17), A55, IF(AND(B56=1, A56 <> A5, A56 <> A11, A56 <> A17), A56, IF(AND(B57=1, A57 <> A5, A57 <> A11, A57 <> A17), A57, IF(AND(B58=1, A58 <> A5, A58 <> A11, A58 <> A17), A58, IF(AND(B59=1, A59 <> A5, A59 <> A11, A59 <> A17), A59, IF(AND(B60=1, A60 <> A5, A60 <> A11, A60 <> A17), A60, IF(AND(B61=1, A61 <> A5, A61 <> A11, A61 <> A17), A61, IF(AND(B62=1, A62 <> A5, A62 <> A11, A62 <> A17), A62, IF(AND(B63=1, A63 <> A5, A63 <> A11, A63 <> A17), A63, " "))))))))))))

    Note B52 to B63 is only either 1 or 0 and A52 to A63 is months of Jan until Dec

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: How to simplify this formula

    Hello and welcome to the forum.

    Please have a look at the forum rules and then change your thread title to describe the problem, not the fact that you have a question.

    It will also help if you could upload a sample file with the expected results mocked up manually.

    cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1