Results 1 to 6 of 6

Alternative for using more nested "'IF"functions

Threaded View

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Kampala, Uganda
    MS-Off Ver
    Excel 2007
    Posts
    3

    Alternative for using more nested "'IF"functions

    I have a matrix measuring the likelihood of a risk occurring and the likely impact. The Ranking are "Low", "Medium" and "High". I can't find figure out the formula that can comprehensively capture it in excel so that when I input the rankings of the two variable, the final ranking will be generated automatically. I have tried to use the IF(AND..... function but it can't capture the whole matrix. I have attached the template i am designing

    I Will appreciate your help
    Attached Files Attached Files

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