Results 1 to 48 of 48

Stuck on correct function(s) & formula!

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2016
    Location
    Rustavi, Georgia
    MS-Off Ver
    2013
    Posts
    54

    Question Stuck on correct function(s) & formula!

    On my spreadsheet tab 'Scores and Assigned Priorities', I have a Baseline score (column D) and a Next Assessment score (column E).

    I need column G to:

    1. know the difference if column D has a score and column E is empty
    2. rate the score in column D when it's by itself AND (E minus D) only when both have a score
    3. rate the D or (E-D) score as 1=high, 2=medium, 3=low, 4= NA, NA=NA

    This is what I have so far, but it's not working when D is the only column with a score in it. I've tried a bunch of OR, AND functions, but that didn't help. I'm out of my league :D

    =IF(SUM(E71-D71)<=0,"HIGH",IF(SUM(E71-D71)<=1,"MEDIUM",IF(SUM(E71-D71)=2,"LOW",IF(SUM(E71-D71)>=3,"NA"))))

    Thanks for any assistance. The file is attached.
    Catherine
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Creating a search function. Stuck on formula.
    By Teblol in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-24-2014, 12:54 PM
  2. Deriving the correct currency from the Data to the SUM if formula function
    By bokergill@gmail.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 06:08 PM
  3. Indirect function formula not correct
    By trobie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2013, 08:30 AM
  4. Stuck at work and stuck on a count function
    By gregfetzer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2012, 12:47 AM
  5. [SOLVED] VLOOKUP Issue - formula correct in function box but not in spreadsheet
    By jlowes in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-25-2012, 12:55 PM
  6. function to check names within formula are correct
    By Macatk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2009, 08:59 PM
  7. Correct VBA syntax for cell function formula
    By mikeburg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-15-2005, 01:05 AM

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