Need help asap on homework

**rysa18** · 05-01-2013, 08:46 PM

I have a homework in which I had to average grades. Here is a picture. I've done everything correctly except the las step which I can't seem to understand. Once you see the image you will understand. I have to substitute the value of the cells under "NOTA #" with the letter corresponding to the number in "NOTA #" under the cell titled "Def"

For example, if the number under "NOTA #" ranges from 100-90 I need to make a formula that makes the letter A under "Def"

A B C D E F
100 - 90 90 - 80 80 - 70 70 - 50 50 - 30 30 - 0
excel.jpg

**wenqq3** · 05-01-2013, 09:26 PM

Solution removed until OP respond to the request of the Moderator (Post #4)

**Lemice** · 05-01-2013, 09:40 PM

Solution removed until OP respond to the request of the Moderator (Post #4)

**FDibbins** · 05-01-2013, 09:45 PM

3 things wrong here...

1. it is against forum rules to do your homework for you
2. Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info)

3Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.