Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Adding missing values (HELP!!)

This is a discussion on Adding missing values (HELP!!) within the Excel Questions forums, part of the Question Forums category; I am trying to do an assignment and am having a really hard time figuring it out. The other steps ...

  1. #1
    New Member
    Join Date
    Nov 2011
    Posts
    5

    Default Adding missing values (HELP!!)

    I am trying to do an assignment and am having a really hard time figuring it out. The other steps I have figured out.

    This is the step:

    In the test score worksheet the range F4:G8 will contain the lower and upper ranges for each letter grade. Add the missing upper range values in the range G4:G7 by inserting formulas in each of those cells that calculates the upper range for each letter grade as being one point lower than the lower range of the next letter grade. any changes to the numeric values in F5:F8 should result in changes to the calculated values in G4:G7.

    Grading Curve
    Lower RangeUpper RangeGradeCountPercentageOptimalDifference
    0F5.0%
    20D10.0%
    40C35.0%
    60B35.0%
    80100A15.0%
    Total100.0%


    PLEASE HELP!!!

  2. #2
    MrExcel MVP mikerickson's Avatar
    Join Date
    Jan 2007
    Location
    Davis CA
    Posts
    16,155

    Default Re: Adding missing values (HELP!!)

    The lower range for a "D" is in F5, so the upper range for "F" (calculated by the formula in G4) would be one less than than that.

    What formulas have you tried? What (if anything) is wrong with the results that they return?

  3. #3
    New Member
    Join Date
    Nov 2011
    Posts
    5

    Default Re: Adding missing values (HELP!!)

    I've tried using the sum, if, >= to, and tried subtracting by 1, but it throws back an error like ?name, ?value. The book doesn't show an example of this so that's why I'm having an issue.

  4. #4
    MrExcel MVP mikerickson's Avatar
    Join Date
    Jan 2007
    Location
    Davis CA
    Posts
    16,155

    Default Re: Adding missing values (HELP!!)

    A basic formula like =A1-2 should work in this situation.

  5. #5
    New Member
    Join Date
    Nov 2011
    Posts
    5

    Default Re: Adding missing values (HELP!!)

    let me try real quick to see if it works

  6. #6
    MrExcel MVP mikerickson's Avatar
    Join Date
    Jan 2007
    Location
    Davis CA
    Posts
    16,155

    Default Re: Adding missing values (HELP!!)

    The formula that I gave isn't the one you want. (I've been trying like mad to avoid doing that).

    If your text doesn't give basic examples like this, you might consult Excel's built-in Help feature.

  7. #7
    New Member
    Join Date
    Nov 2011
    Posts
    5

    Default Re: Adding missing values (HELP!!)

    Ok I got it but now something else doesn't want to work. It says that if there's perfect correspondence that L9 would be zero. Well it is showing 56.36%. =COUNTIF($D$4:$D$223,H4) for the Count, =I4/220 percentage, =abs(j4-k4) difference,


    Grading Curve
    Lower RangeUpper RangeGradeCountPercentageOptimalDifference
    059F5424.5%5.0%19.5%
    6069D4118.6%10.0%8.6%
    7079C6027.3%35.0%7.7%
    8089B3415.5%35.0%19.5%
    90100A3114.1%15.0%0.9%
    Total220100.0%100.0%56.36%
    56.36%
    4
    TRUE
    100
    100

  8. #8
    New Member
    Join Date
    Nov 2011
    Posts
    2

    Default Re: Adding missing values (HELP!!)

    Hey lenakjm

    what formula did you use to find the upper range?

    Nevermind I got it. I feel dumb now how easy that was.
    Last edited by BlueCore; Nov 16th, 2011 at 03:52 PM.

  9. #9
    New Member
    Join Date
    Nov 2011
    Posts
    5

    Default Re: Adding missing values (HELP!!)

    I felt like a complete idiot especially since it was something that easy.

  10. #10
    New Member
    Join Date
    Nov 2011
    Posts
    1

    Default Re: Adding missing values (HELP!!)

    I still don't get it how do you find the upper range value ? If I do =F-1
    upper rage will be 19 ? not 59 ? how did you get 59 ? and why did you change all the lower range value ?

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com