Results 1 to 1 of 1

Help require to delete or reduce extra marks

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Help require to delete or reduce extra marks

    Hi,

    The rules changes time to time as per education policy structure of grace marks. So I want to delete the extra grace marks or reduce the extra grace marks >10 to 10 as per the second condition.

    A student will get maximum 10 grace marks in a single subject. In short if the student has 23 marks then he will not get 12 grace marks but he will get only 10 grace marks. He will not pass in that particular subject. In this case after giving grace marks if the student is not reaching the passing marks that is 35 and 18 then no need to give grace marks; though the total of grace marks is not 15.
    Secondly, the student will get grace marks maximum in only 4 subjects. These 4 subjects should be the highest. If the student has 6 subjects in which he is eligible of grace marks then the top 4 subjects get grace marks limit to 15.

    Please suggest me a code to achieve the target automatically.

    Thanking you.
    Attached Files Attached Files
    Sincerely,

    mso3

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Require a code to delete cell range
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2014, 06:35 AM
  2. How to reduce the array size without delete content
    By cgkmal in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-20-2013, 02:14 AM
  3. Require macro to reduce data by averaging
    By dpgillies in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2010, 08:53 AM
  4. Getting Rid of Extra Quote Marks in Exported Text Files
    By gabrielhuebsch in forum Excel General
    Replies: 0
    Last Post: 04-07-2010, 01:27 PM
  5. [SOLVED] Saving Spreadsheet to Unicode extra quotation marks
    By effendi@epitome.com.sg in forum Excel General
    Replies: 0
    Last Post: 01-26-2006, 11:25 AM

Tags for this Thread

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