Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# Problem with excel spreadsheet formula

### #1 harrop1 Posted 17 July 2006 - 08:25 AM

harrop1

New Member

• Member
• 2 posts
Hi,

I have made a simple Gradesheet for recording students grades, and progressively calculating the average letter grade at the end of semester one and semester two.

My problem is that I need a formual that will automatically round up the letter grade (based on 1-15 points, where E- equals 1, and A+ equals 15) when the point value is 0.75 or higher.

Eg. A "C" equals 8 points, a "C-" equals 7 points and a "C+" equals 9 points. If a grade average is 8.75 - or higher, I need it to round up to 8 for the "C" grade.

I'm a real beginner with this, so feel free to chop or change anything in the spreadsheet.

Any help will be much appreciated!

I tried to attach the spreadsheet but the system disalowed it with that extension. I'm not shure what to do ...
• 0

### #2 fructose Posted 19 July 2006 - 12:28 PM

fructose

Retired Staff

• Retired Staff
• 284 posts
I think I see what you are trying to do. Can you zip the file up and attach it that way? Just browse to the file in My Computer and right click on it and select Send To > Compressed (zipped) folder.

I'll take a look and see if I can figure it out for you.
• 0

### #3 harrop1 Posted 19 July 2006 - 03:42 PM

harrop1

New Member

• Topic Starter
• Member
• 2 posts
Thanks for the offer Fructose, but I just managed to work it out.

J
• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users