At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.
Hi Tina, See attached. Equals, in D6 Summary tab, from Total from Homework tab. See tabs at bottom of spreadsheet which allow you to move between tabs to select input to the Summary sheet. Hope this helps.
Okay, type = in D6, then go to the Homework tab and click on 93 in the totals column, then flip back to the Summary tab. Then look in the formula bar, your done:)
Tina, Not sure, try re-saving the version you want to keep. You can now fill the whole column by pulling the formula down the column:) The formulas will change automatically and pull the input from the Homework tab. Try it:)
how do i do that?
Go to D6 in Summary tab, then grab the little plus sign in the bottom corner of the cell and pull it down the column. What you are doing is copying the formula downward.
WOW! wish I would have learned that sooner
Ha! You made an old man laugh! You get a medal for that:)
I hope this was a help to you:)
it really is I am really new to Excel, and the class I am taking is getting to be frustrated. To calculate the total points for each student in column H, would be =sum(D6:G6)?
Hang on Tina, let me check it:)
SUM should be capitalized
Ty, and do you by any chance know how to name a cell? next step says to name cell H25. Thank you for the tip
H25 contains the number 825 on the Summary tab which is a total of line 25. Is there a next step?
it says to name the cell, I figured that part out, you click on H25 and and then click on name a range
Yes, the range should extend from D to G with the total displayed in H:)
but I am having trouble with an IF statement =IF(I6>0.899,"A",IF(I6>0.799,"B",IF(I6>0.599,"D","E")))
Did you try playing with it in a formula bar to see what results you got?
yes it is suppose to be the letter grade but the grade I am getting is not whats on the sample sheet
Have you populated row 6 in the summary sheet from the other 4 tabs?
yes all columns have been filled in with the correct values
Okay, post a copy of that sheet for me:) Then I will try it to see what happens:)
Formula is good =IF(I6>0.899,"A",IF(I6>0.799,"B",IF(I6>0.599,"D","E"))) Click on I6, they named H25 as POSSIBLE POINTS which is 825. Check that in your file. Also check to see you are carrying the percent input to two decimal places:)
the sheet i sent was my assignment, i dont have a copy of the sample sheet it is in the textbook. That grade that is on the sample sheet all the D's on my sheet are C's on the sample sheet. The next step says to review the Summary worksheet and make any necessary formula and/or formatting changes.
Okay, the sheet file "gradebook" is your's. Did the text get 825 for H25?
I see that, no Cs. Okay, let me look:)
Found it. Ha! Modify your IF statement to include Cs:)
Make sure you save the new file:)
oop's almost forgot that would have sucked.
Ha! I am on Pacific time and half a bottle of Jack later:) brown19472002@ yahoo.com Glad to have been a help, anytime:)
I am on Eastern I will be up for a long while Internet was down for the last 3 1/2 days I am an Accounting Major, beginning my second year. Do you drink your Jack straight or mix? And do you use Yahoo messenger?
Oh Wow, not good. Straight up! BS in Information Systems, MBA w/Finance emphasis, MS Accounting, MS Financial Management & PMF Fellowship finalist. Yes, but slow typing:(
Put my email address in your Yahoo contacts list, you should see my email account as open:)
I think I just found my new best friend, I am working on my BA in Accounting, and I am always on here looking for help, midterms next week. Then its on to Peach Tree.
and I like my jack with a little Dew
Dew will do! Well, the best to you on exams. Peach Tree should be fun after IF statements. Ha! Most of my children and grandchildren are on the east coast, MD, DE & VA.
I am in FL, just moved back here from CO. Thank you for all your help and patience. Looking forward to PT. So now that I know your educational background what was your overall career choice
Most welcome, any time Tina. I work for the Army Corps of Engineers, civilian employee in Construction Management, Contract Administration and negotiation. How long before you have your BA and where do you want to work? How about a CPA?
I graduate god willing, Dec 2014. I actually want to have my own Accounting firm one day , but not 100% sure. Tax auditor for the IRS, is a thought. I think it would be alot less complicated if I had a good mentor. I am my only support. Thank god for Open study, I would have given up in my Algebra class. Well Mr. Brown may I have the pleasure of knowing your first name?
I forgot a step on my grade book, it says to revise the file to calculate the grade using VLookup function?
Ha! Hugh will do:) VLookup function, Okay, we should be able to look up the protocols for that.
Your email address says it is invalid brown19472002@ yahoo.com?
Okay, send me an email and I'll check to see if I receive it, that is the right address:)
Worked for me:)
The Excel HELP screen gives a good example for the VLookup function.
please explain how to do help gives lots of examples?
=VLOOKUP(1,D6:I23,2) Am I atleast close because it is not working?
Hang on:) Let me check how you are using it:)
=VLOOKUP(606,A2:J23,8,FALSE) Will get you going:)
It needed an Identifier, ID number, from left-side column A, a range of cells, and argument, i.e. False:)
ok so the next one should be =VLOOKUP(943,A2:J23,8,FALSE)?
Hang on, let me check:)
Figured it out:) =VLOOKUP(943,A2:J23,10,FALSE) Create an extra column at line 6 paste this formula and copy the formula down the column, just like before, you will be surprised:)
Oh! Will need Absolute $ address to get formula to change on the copy:)
Where do I put those in?
ID numbers, Okay, you will have to change each line formula to use to proper ID number, try it:)
Use a separate column to play with this until you get the results you want. Save file:)
ID 943 for second line, it works:)
i.e. Third line formula =VLOOKUP(983,A4:J25,10,FALSE) should display a grade of D and so forth down the sheet, you will only have to change the ID number for each line in your formula.
Let me know you got it to work for you:)
should I be getting a letter or the same as the total column?
Right! A letter grade; note I changed the 8 to a 10 in the base formula:) Should match the grade in your column figured previously:)
when i put the 10 in it it gives me a circular reference warning then goes to 0
Copy and paste here your line 6 formula:)
=VLOOKUP(606,A2:J23,10,FALSE) Ha! Change the 8 to a 10, you have it:)
i get a 0
You will then copy down the formula. Then you only have to go back and manually change the ID number per row formula:)
Huh? You in line 6?
Are you beginning the test column K starting next to the cell with the D grade, 1st row, line 6? Something like this: ID # Last Name First Name Homework Projects Quizzes Exams Total Percent 000606 Altiveros Melissa 93 312 33 213 651 78.91% Letter Test D D
Check to make sure the formula is in K6:)
it is now i got letters now
All Right:) Just change the ID number in each row formula, nothing else:) I am going to bed! Get up at 4. Email when you need help:)
I will ty for all your help. good night sorry if i kept you up
No Jack left :( Bottle is empty:( Later:)