# Cannot find a formula that converts fine grades, to whole grades......

1. ## Cannot find a formula that converts fine grades, to whole grades......

First of all, 'Hi' to everyone.

I've recently been made Data Manager at a secondary school in the UK, and that means LOTS of Excel is needed. I have watched some of the excellent Mike Girvin's videos on YouTube under his Excel Is Fun banner, but I'm searching for something that, on the face of it, sounds simple - but I'm a bit stumped.

I have columns on worksheets that see students' exam target grades at 6+, 6, 6- etc for example, and these numbers with + or - are called 'fine grades'. I want to copy into a column called 'Strong Grades', which are whole numbers. So, I'm looking for the formula that every time it sees a 7- or a 7+ for example, it converts it to a simple 7; 6- or 6+ becomes just an ordinary 6, and so on.

Is this easily done? I'm sorry for asking something so basic, but I'm just a bit puzzled.

All the best.

2. ## Re: Probably a simple one for you guys.......

Your 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 go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

3. ## Re: Cannot find a formula that converts fine grades, to whole grades......

Hi all- it appears that you have amended your title, so:
This discards the sign and returns positive numbers:
...while this returns negative OR positive numbers:

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1