Results 1 to 2 of 2

Thread: please help with a formula that solves the problem

  1. #1

    please help with a formula that solves the problem



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

    dear members,
    i want to know if there's any formula that can be used to solve the following:

    I have data from cell A to cell I either "Y" or "N", and I want a result in cell J, using the data of that row.
    now the conditions are:
    if none of the cells have "Y" then cell J will show "ALS"
    if only one of the cell from A to I has "Y" then cell J will show "MONO"
    if more than one cell has "Y" the cell J will show "POLY"

    now the trick starts from here......
    if more than 1 cell is "Y" and both the Cell A and B have "Y" then cell J will show "MDR", else "POLY"
    if cell A, B, F and any one or more than one cell from G to I have "Y" then it will show "XDR" else "POLY".

    thanks for any help in this. i am attaching a file. i hope it will better explain the problem. workbook001.xls

  2. #2
    Keep it simple

    =IF(COUNTIF(A3:I3,"Y")=0,"ALS",IF(COUNTIF(A3:I3,"Y")=1,"MONO",IF(AND(A3="Y",B3="Y"),IF(AND(F3="Y",COUNTIF(G3:I3,"Y")>0),"XDR","MDR"),"POLY")))

Posting Permissions

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