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. ## 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 Range Upper Range Grade Count Percentage Optimal Difference 0 F 5.0% 20 D 10.0% 40 C 35.0% 60 B 35.0% 80 100 A 15.0% Total 100.0%

2. ## 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. ## 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. ## Re: Adding missing values (HELP!!)

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

5. ## Re: Adding missing values (HELP!!)

let me try real quick to see if it works

6. ## 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. ## 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 Range Upper Range Grade Count Percentage Optimal Difference 0 59 F 54 24.5% 5.0% 19.5% 60 69 D 41 18.6% 10.0% 8.6% 70 79 C 60 27.3% 35.0% 7.7% 80 89 B 34 15.5% 35.0% 19.5% 90 100 A 31 14.1% 15.0% 0.9% Total 220 100.0% 100.0% 56.36% 56.36% 4 TRUE 100 100

8. ## 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.

9. ## Re: Adding missing values (HELP!!)

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

10. ## 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 Last

#### Posting Permissions

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