Results 1 to 5 of 5

Excel 2007 : calculate value based on multiple low, medium, high cells

Threaded View

lauriec calculate value based on... 01-12-2011, 05:35 PM
fiddle2oons Re: calculate value based on... 01-12-2011, 05:52 PM
DonkeyOte Re: calculate value based on... 01-12-2011, 06:00 PM
lauriec Re: calculate value based on... 01-12-2011, 05:59 PM
lauriec Re: calculate value based on... 01-18-2011, 10:47 AM
  1. #1
    Registered User
    Join Date
    01-12-2011
    Location
    Texas, US
    MS-Off Ver
    Excel 2007
    Posts
    3

    calculate value based on multiple low, medium, high cells

    I'm trying to figure out how to calculate a score based on whether or not the user entered an "x" in various cells. I've got 11 columns in my spreadsheet:

    Column 1 represents a new feature the user wants

    Columns 2 - 4 are used for indicating the significance as low, medium or high (user puts "x" in only one column).
    Columns 5 - 7 are used for indicating the effort as low, medium or high (user puts "x" in only one column).
    Columns 8 -10 are used for indicating the risk as low, medium or high (user puts "x" in only one column).

    In Column 11, I want to calculate a score based on the low, medium and high entries where low = 1, medium = 2 and high = 3. The minimum calculated scored is 3 and the max is 9.

    Suggestions?
    Last edited by lauriec; 01-18-2011 at 01:37 PM.

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