Function To Convert Marks Into Grade

Nov 15, 2013

I am looking for a function that would convert any mark into a grade. For example in cell B4 I want to enter the total score, cell c4 the score that a student gets and in cell d4 the grade. It is like a grade calculator. I do not want to limit cell b4 the total score cell with a specific total score number. It can be 100, 50, 30 or 10. The moment I enter any total score and the mark that a student actually scored, the grade is given. I attached an excel sheet.

Marks and Grades Calculator.xlsx‎

View 12 Replies


Convert The Grade To A Number But VLOOKUP Not Getting The Difference Between A And A*

May 5, 2006

I'm putting together a mark book for school and have a problem with VLOOKUP distinguishing between what used to be a top grade, ie A, and the new top grade, A*.
I want to convert the grade to a number but VLOOKUP can't tell the difference between A and A*. I've attached a sample worksheet.

View 8 Replies View Related

Compare Actual Grade To Potential Grade And Highlight Cells

Jul 10, 2013

I am compiling a master spreadsheet to analyse progress of students. I have their potential grades in one column and their latest progress grade in another.

I would like an automatic look up of the potential to the progress grade so that if their current grade is BELOW their potential that gets highlighted one colour, if it is above, another colour.

One issue is that the grades are all letters (S, A, B, C, etc.) and that some potential grades are 'dual' (i.e. A/B, S/A) which complicates the issue somewhat.

View 7 Replies View Related

Calculate Final Grade Based On Grade Table

Jun 13, 2006

my Excel teacher doesn't even know how to do this! The chapter is Working with Multiple Worksheets and Workbooks, and we went into linking workbooks, linking worksheets, using the VLOOKUP function, and saving workbooks as templates. This is Case Problem 2 and i'll attaching the file.

It says:

1. On the Grading Criteria worksheet, enter the text "Exam Average" in cell A1
and the text "Grade" in cell B1.

2. In the range A2:B6, create a lookup table for the range of grades specified by Professor Templeton. (Hint: Each letter grade should be matched up with the lowest score possible for that grade.)

Here are the specified grades:
0 to 49 = F
50 to 59 = D
60 to 74 = C
75 to 89 = B
90 to 100 = A

3. Insert a formula in Column E of each worksheet to calculate the overall score of each student based on the grade table you entered in the Grading Criteria worksheet.

View 9 Replies View Related

Count Function :: For Students And Grade

Jan 28, 2009

I have a problem with counting the number of students assigned to each professor and determining the number of students who have passing grade. Let say that the passing grade is 80.

View 9 Replies View Related

Can't Find Function To Show A Progressing Grade?

May 21, 2014

I am trying to find a function to calculate the percentage grade as the semester progresses. I'm attaching an example of my sheet what I need is column "D" to show the grade percentage from columns "E"-"AK" as each grade is entered.

View 3 Replies View Related

Change Letter Grade To Number Grade

Mar 30, 2008

I have a range of cells C11:C29,G12:G18,G20:G23,G25:G26,G28:G29,C33:C42,G33:G42,C46:C47,G46:G47,C51:C54,G51:G59,C58:C59 that contains letter grades (egs. A+,C- etc). I need the code for a macro that checks each cell from this range and if the value of the cell is A+ then the cell's value changes to 100, if the cell's value is A then change the cell's value to 98, if cell's value is B+ then change to 88 ...and so get the idea (i will complete the rest of conditions but i just need the basic code).

View 6 Replies View Related

Convert Function GetComputerName To VBA

Dec 7, 2007

I don't have a clue as to how to convert this to VBA code.

When installed as a macro, the function works fine in a cell on my PC, but when I send the file to another pc, it still gives the name of my pc. I need it to return the name of thier pc.

View 14 Replies View Related

Convert It To A Usefull Function I Get A #Name

Dec 7, 2009

Sub xxxxxxx()
Keli = Cells(13, 8).Value
Valid1 = Application.WorksheetFunction.VLookup(Day(Keli), Range("ToTalList"), 2, False)
Valid2 = Application.WorksheetFunction.VLookup(Month(Keli), Range("ToTalList"), 3, False)
Valid3 = Application.WorksheetFunction.VLookup(Int(Year(Keli) / 100), Range("ToTalList"), 4, False)
Valid4 = Application.WorksheetFunction.VLookup(Year(Keli) - Int(Year(Keli) / 100) * 100, Range("ToTalList"), 5, False)
MsgBox Valid1 & " " & Valid2 & " " & Valid3 & " " & Valid4
End Sub

When I try to convert it to a usefull function I get a #Name? Error
What do i do wrong? The purpose is to create a date in to words function

Public Function DateInWords(Keli As Range)
Valid1 = Application.WorksheetFunction.VLookup(Day(Keli.Value), ThisWorkbook.Worksheets(1).Range("ToTalList"), 2, False)
Valid2 = Application.WorksheetFunction.VLookup(Month(Keli.Value), ThisWorkbook.Worksheets(1).Range("ToTalList"), 3, False)
Valid3 = Application.WorksheetFunction.VLookup(Int(Year(Keli.Value) / 100), ThisWorkbook.Worksheets(1).Range("ToTalList"), 4, False)
Valid4 = Application.WorksheetFunction.VLookup(Year(Keli.Value) - Int(Year(Keli.Value) / 100) * 100, ThisWorkbook.Worksheets(1).Range("ToTalList"), 5, False)
DateInWords = Valid1 & " " & Valid2 & " " & Valid3 & " " & Valid4
End Function

View 9 Replies View Related

ACOS Function: Convert Using COS

Sep 11, 2006

i am trying to get COS to perform correctly, Basically i have an equation, that gives me a figure i want to convert using COS. My scientific calculator allows me to press invert, then i press COS this gives me the correct mesurement.

Cos .22553 = 77 degress

To get excel to work it out is deluding me

View 3 Replies View Related

Convert Mid & Find Function To Vba

Oct 18, 2007

I am writing VBA code that dissects a cell which always contains some alphanumeric characters a colon ":", some more characters, another colon ":" and some more characters.

For Example this is what is in my cell "Deposit:93121:Southern California"

what I need is to cut and paste everything that is located after the 2nd colon ":"

Say that my cell is D433 and in non-vba world I can chop off the first part of the cell to the left of the first colon ":" by using the following formula:

=MID(D433, FIND(":",D433)+1,50)

assuming there are less than 50 characters in my cell, which is a safe number, then I cut and pastespecial this cell as values into the same cell and repeat that same formula and voila, what remains in cell D433 is what I am looking for "Southern California"

how can I replicate this surgical process in VBA, is there a way to combine this process in one command on any given target cell?

View 3 Replies View Related

How To Convert From COUNTIFS To SUMPRODUCT Function

Feb 25, 2014

convert this equation into sumproduct function..??


View 6 Replies View Related

Function To Convert All To Upper Case?

Oct 24, 2012

In cells A1:A45 i have all lower case would i use a function to convert all to upper case

View 6 Replies View Related

Function To Convert Long Value Into IP Address

Jul 29, 2014

Any function to convert a long value into an IP address. I have an extract from a mySQL dbase that has the ip addresses in long format. I need to reverse them back to IP Addresses.

View 1 Replies View Related

Convert String To Object Or Function

Apr 11, 2007

I do not know if this is possible in VBA, but I am hoping it is as it will make my life much easier.

Is it possible to say have a TextBox and a CommandButton, that does the following?

Public Sub Execute()

Dim ObjectName As String
Dim Object As Object

ObjectName = txtObject.Text
Set Object = ObjectName


End Sub

Or to take it a step further:

Public Sub Execute()

Dim ObjectName As String
Dim FunctionName As String
Dim Object As Object

ObjectName = txtObject.Text
FunctionName = txtFunction.Text
Set Object = ObjectName


End Sub

Are there any inbuilt functions that will create/reference an object based on a string containing the name of the object or function?

View 9 Replies View Related

How To Convert IF Nested Function In Macro

Feb 10, 2008

i have several days trying to convert a If nested function in a automate macro, the problem is that i have a lot of formulas, and the machine becomes slow, so i have to apply this formula to "column G"


View 9 Replies View Related

Transpose Function: Convert The Worksheet

Nov 18, 2008

I currently have a Tab named "Rent by Month 3-08-5-29" containing the monthly rent amount for 700 locations for March 2008 - May of 2029 with the layout seen below.

Shop# 3/1/2008 4/1/2008 5/1/2008 6/1/2008 ETC..
2 $5000 $5000 $5000 $5000
3 $3000 $3000 $3000 $3000
4 $7000 $7000 $7000 $7000
18 $4000 $4000 $4000 $4000
ETC... continuing down 700 rows and over 251 columns

What I need to do is convert this worksheet so it contains the same information but resembles the following layout.
Shop# Month Rent Amount
2 3/1/2008 $5000
2 4/1/2008 $5000
2 5/1/2008 $5000
2 6/1/2008 $5000
3 3/1/2008 $3000
3 4/1/2008 $3000
3 5/1/2008 $3000
3 6/1/2008 $3000

View 10 Replies View Related

Function Convert Codes Automatically

Mar 22, 2006

I have entered a lot of functions mainly VLOOKUPs. I want to write VBA codes for the functions without manually writing them. Is there a way in which I could get the manually written functions converted to codes automatically?

View 9 Replies View Related

If Function With Letters - Calculate And Convert Units

Apr 11, 2012

I am making an IF function that calculates and converts units, for example kg to g and g to kg etc.

This is the formula I typed in

=IF(E6=kg, ((F6/D6)*G6/1000), ((F6/D6)*G6))

When I evaluate it I get the #NAME error. What do I need to change to make it work?

View 3 Replies View Related

Convert Nested Formula Into Custom Function

Jan 31, 2008

is there a way to turn the following formula into a function ?

=IF( COUNTA(A1:A7)=SUMPRODUCT((A1:A7<>" ")/COUNTIF(A1:A7,A1:A7&"")),"No Duplicates","Duplicates")

I just have no idea where to start ?

View 4 Replies View Related

Amendments In Function Convert Digits To Words (US Dollar)

Nov 1, 2009

Before I got this Function from your Form to convert digit to words.

Function is as following..right now i m getting as following:-

If i type 123..i m getting one Hundred twenty Three with this script as below.

But i want US Dollar one Hundred Twenty Three..

Can any one add the word "US Dollar" in this script.


Function English(ByVal N As Currency) As String
            Const Thousand = 1000@
            Const Million = Thousand * Thousand
            Const Billion = Thousand * Million
            Const Trillion = Thousand * Billion

View 13 Replies View Related

Cstr Function: Convert A Range Of Numbers To Text

May 13, 2006

i am trying to convert a range of numbers to text using the Cstr function ,it doesnt work. excel VBA help states that CStr function converts a numeric value to a String. i am aware that i can convert a number by preceding it with an apostrophe
i just need to know why Cstr doesnt do the job

Sub covrt()
For Each rng In Selection.Cells
rng = CStr(rng.Value)
End Sub

View 3 Replies View Related

Convert Logic Function To Data Cell Validation

Jul 2, 2007


how can i use the data cell validation using the above function logic?

View 2 Replies View Related

Hash Marks

May 30, 2007

I have my columns set at a certain width, the cells set to Wrap Text, the Row set to Autofit YET sometimes when I add text, the hashmarks show up as if the cell isnt formatted correctly and Excel cant show all the text. I can resize the cell, change the text whatever, nothing changes. The only way I can fix this is to cut the text out, open a separate worksheet, paste the text into a cell and copy the whole cell BACK into the original spreadsheet, then I have to reformat the text, whereupon it behaves as it is supposed to.

I read about a similiar problem and the reply was that a macro might be causing the error. This is not the case here. This doesnt happen with any regularity so it is very difficult to figure out.

View 14 Replies View Related

Getting Rid Of Tick Marks

Nov 28, 2008

Some sent me a large spreadsheet with random rows throughout the spreadsheet highlighted in diffierent colors. I have a module that will sort the spread sheet by Color - however it doesn't work on this spreadsheet because - for whatever reason - every cell starts with a tick mark.

I tried to do a replace all - and excel just told me I was crazy.

I even tried going through and manually removing the tick marks - still no luck.

If I export the sheet in to txt and then re-import it I will loose all the highlights...

View 9 Replies View Related

Convert Combination Of Excel Functions Into One User-defined Function

Mar 12, 2014

I have a really long function which counts the number of unique values in a selected range, and ignores blank cells. The function is like this (only works as an array function):


I want to convert this into a user-defined function COUNTUNIQUE, which only takes one argument: the range (A1:A15 in the above example)

View 6 Replies View Related

Formula For Segregation Of Various Grade?

Feb 20, 2013

Here in "Grade" Column wants put a formula so that it will show First,Second,third and Fail. If the Mark is more than or equal 40 but less than 50 will reflect Third,if the mark is more than or equals to 50 and less than 60 will reflect Second, if the mark is more than or equals to 60 will reflect First and remaining less than 40 will reflect fail.

View 2 Replies View Related

Formula To Put The Grade And Rate Beside Each Name

May 12, 2007

FromToGr Rate

This is part of a marks to grade and rating table. I have a list of students and the marks they obtained in an exam. I need a formula to put the grade and rate beside each name e.g. John; 92 marks; A1; 4.

View 9 Replies View Related

Formula To Consolidate Marks

May 22, 2012

I have three worksheets in which the marks are entered.Now i want to consolidate the marks like

1 in sheet1 2 in sheet2 3 in sheet3 now i want to omit the min(1) marks and add/average of remaining two((2+3)/2)*100.

Is there any formula for this!

View 2 Replies View Related

Matching Name Range With Achieved Grade?

Sep 15, 2014

I am trying to find lists of students from this worksheet who obtained the Grades in column K4, K12 and K19 together with their own classes. Is there any formula besides Pivot Tables to find them?

View 6 Replies View Related

Copyrights 2005-15, All rights reserved