• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. L

    Stumped on CF

    Hi All, Thank you for the quick replies. Narayank991, it worked when I copied your table over mine.... bobhc, your solution worked as well. Once again thanks. Len
  2. L

    Stumped on CF

    Hi, I have the following formula in k37 =INDEX(Matrix,MATCH(I37,Consequence),MATCH(H37,Likelihood,0)) The Matrix table is Likelihood 0 5 4 3 2 1 1 Low Medium High Very High Very High 2 Low Medium High High Very High 3 Very Low Low...
  3. L

    If aused several times

    Hi, Thank you all, You guys are excellent, both formula worked. Thans Len
  4. L

    If aused several times

    Hi Amrit1186 If A1=0 and B1=0 and C1=0 then D1 = 1 or If A1=1 and B1=1 and C1=0 then D1 = 2 or If A1=0 and B1=0 and C1=1 then D1 = 3 or If A1=0 and B1=1 and C1=1 then D1 = 4 or If A1=1 and B1=0 and C1=1 then D1 = 4 or If A1=1 and B1=1 and C1=1 then D1 = 5 Hope this makes more sense...
  5. L

    If aused several times

    Hi all, I am trying to work out the following by using the if statement, at one stage the answer will equal to an other but it is OK I have 4 Columns A, B, C an D D is were I want the formula In the 3 cells, there is a combination of results, A1 B1 C1 D1 =...
Back
Top