+ Reply to Thread
Results 1 to 2 of 2

High Medium Low Surveys

  1. 05-27-2019, 05:44 AM #1
    Sunaila
    Sunaila is offline
    Registered User
    Join Date
    05-24-2019
    Location
    Pakistan
    MS-Off Ver
    2013
    Posts
    1

    High Medium Low Surveys

    What is the best way to calculate high medium low % for below kind of survey

    1111.png
    Reply With QuoteRegister To Reply
  2. 05-27-2019, 05:55 AM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,408

    Re: High Medium Low Surveys

    It's just HIGH divide by sum of (HIGH, MEDIUM and LOW), formatted as a percentage, and similar for the MEDIUM and LOW %age.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. And / If - greater & less than values to produce "low, medium, high, critical, imminent"
    By ScrappyDoo1911 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-21-2017, 01:30 PM
  2. How to get the overall complexity result base on Low, Medium and High
    By Ex-xcel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-18-2013, 01:18 PM
  3. [SOLVED] High Medium and low
    By mobileangus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-18-2013, 09:42 AM
  4. Need to generate a chart with data rated on High, Medium, Low scale
    By dbalam in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2012, 06:58 PM
  5. Median of High, Medium, Low - Excel 2007
    By princesseileen99 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-17-2012, 01:22 PM
  6. Excel 2007 : calculate value based on multiple low, medium, high cells
    By lauriec in forum Excel General
    Replies: 4
    Last Post: 01-18-2011, 10:47 AM
  7. [SOLVED] Calculate weighted averages using high, medium, low
    By JimDandy in forum Excel General
    Replies: 7
    Last Post: 01-01-2009, 04:04 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1