+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    01-03-2018
    Location
    Sussex, England
    MS-Off Ver
    2016
    Posts
    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.
    Last edited by GW1066; 01-03-2018 at 04:07 PM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,423

    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. #3
    Valued Forum Contributor leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    1,987

    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:
    Please Login or Register  to view this content.
    ...while this returns negative OR positive numbers:
    Please Login or Register  to view this content.
    Last edited by leelnich; 01-04-2018 at 10:37 PM.
    Please click the Add Reputation star below any helpful posts, and mark your thread as SOLVED (Thread Tools, up top) once you have your answer. Thanks!-Lee

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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