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
ADVERTISEMENT
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
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
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
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
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
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 on...you get the idea (i will complete the rest of conditions but i just need the basic code).
View 6 Replies
View Related
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
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
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.
I.E.
Cos .22553 = 77 degress
To get excel to work it out is deluding me
View 3 Replies
View Related
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
Feb 25, 2014
convert this equation into sumproduct function..??
=COUNTIFS($I3,">="&$AC$3,$I3,"<="&$AC$4)
View 6 Replies
View Related
Oct 24, 2012
In cells A1:A45 i have all lower case names...how would i use a function to convert all to upper case
View 6 Replies
View Related
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
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
Object.Execute
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
Object.FunctionName
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
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"
=IF(LEFT(F2;1)="J";"C";IF(LEFT(F2;1)="g";"C";(IF(ISERROR(VLOOKUP(F2;rifs;1;FALSE));"NC";"C"))))
View 9 Replies
View Related
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.
A B C D E
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.
A B C
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
Etc....
View 10 Replies
View Related
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
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
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
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.
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
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)
Next
End Sub
View 3 Replies
View Related
Jul 2, 2007
=IF(WEEKDAY(D3,2)=7,"WEEKEND",IF(WEEKDAY(D3,2)=6,"WEEKDEND",IF(TODAY()=D3,"TODAY",IF(TODAY()-3=D3,"FRIDAY","ERROR"))))
how can i use the data cell validation using the above function logic?
View 2 Replies
View Related
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
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
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):
{=SUM(IF(FREQUENCY(IF(LEN(A1:A15)>0,MATCH(A1:A15,A1:A15,0),""),IF(LEN(A1:A15)>0,MATCH(A1:A15,A1:A15,0),""))>0,1))}
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
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
May 12, 2007
FromToGr Rate
90100A14.0
8689A23.6
8085B13.2
7279B23.0
6471B32.8
5663C12.6
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
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
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
