• 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, 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...
  2. 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