# Excel Adjusting formula

October 26, 2010 at 07:19:12
Specs: Windows Vista
 I need to adjust the last column with the statements below. If anyone can help it would greatly appreciated. Thank you. ID-Key Exl-1 Exl-2 Exam Semester Sem % Exl Total Exl % Adjusted % 1136 20 26 70 116 72.50% 46 76.67% 1259 15 25 84 124 77.50% 40 66.67% 1324 20 23 57 100 62.50% 43 71.67% 1459 17 28 73 118 73.75% 45 75.00% 2207 15 24 83 122 76.25% 39 65.00% 2608 20 28 78 126 78.75% 48 80.00% 2655 20 23 63 106 66.25% 43 71.67% 2785 20 27 68 115 71.88% 47 78.33% Possible 20 40 100 160 100% 60 100% 100% Avg 18.4 25.5 68.4 115.875 72.40% 43.875 73.10% 69.90% Avg % 92% 64% 68% 72% 72.40% 73% 73.10% 69.90% Adjusted Column: A. If a student's Exl % is less than Semester % by 20% or more, lower the semester % by 15%; B. If a student's Exl % is less than Semester % by 10% or more, lower the semester % by 10%; C. else, the student gets to keep his semester % one formula should work for all of the Adjusted column

See More: Excel Adjusting formula

#1
October 26, 2010 at 09:05:46
 Please repost your table(s) after following these instructions. It will make it easier for us to read and understand the output you are looking for.Thanks!DerbyDad03Office Forum ModeratorTo line up the data/tables in your post, please use the
tag found above the Reply box.1 - Click the
icon found above the Reply box.2 - Enter your data/table between the tags.3 - Click Preview Follow Up to see if you like the way it looks. 4 - If you need to fix the layout, fix it in the Message box below the Preview box.5 - Click the "Check To Show Confirmation Page Again" box.6 - Click either Confirm button to Preview the post again.Repeat steps 4 – 6 as often as necessary until you like the way the post looks and then click Confirm.

Report •

#2
October 26, 2010 at 12:03:41
 Thank you. Hope this helps` Exl-1 Exl-2 Exam Semester Sem.% ExlTotal Exl% Adjusted %`` 20 26 70 116 72.50% 46 76.67 `` 15 25 84 124 77.50% 40 66.67% `` 20 23 57 100 62.50% 43 71.67% `` 17 28 73 118 73.75% 45 75.00% `` 15 24 83 122 76.25% 39 65.00% `` 20 28 78 126 78.75% 48 80.00% `` 20 23 63 106 66.25% 43 71.67% `` 20 27 68 115 71.88% 47 78.33% `Possible` 20 40 100 160 100% 60 100% 100% `Adjusted Column: A. If a student's Exl % is less than Semester % by 20% or more, lower the semester % by 15%; B. If a student's Exl % is less than Semester % by 10% or more, lower the semester % by 10%; C. else, the student gets to keep his semester % one formula should work for all of the Adjusted column

Report •

#3
October 26, 2010 at 12:15:24
 Is this homework?

Report •

Related Solutions

#4
October 26, 2010 at 12:19:32
 Homework/practice for test on this material

Report •

#5
October 26, 2010 at 14:26:50
 Can anyone help me with this?

Report •

#6
October 26, 2010 at 14:47:31
 Help will come when we have time.We see your question and will offer what help we can, when we can.Asking for help multiple times will not endear you to us, so please be patient.

Report •

#7
October 26, 2010 at 14:55:20
 The only reason I ask again is because I have been trying to do this forever and can't figure it out and I have class in about half hour and want to have this ready. Thanks

Report •