R_N_WARD
asked on
NEWBE
I am a beginer in VISBASIC and need some help. I want to instruct the computer to take a value from a cell (namely, N3) in an Excel database, devide it by another cell (N21) take the sum and give it a text value (ex. "A","A-","B+", ect.),and ,finaly, Print the text value to (O3). Please E-Mail Me if You have a suggestion
ASKER
Adjusted points to 60
ASKER
Adjusted points to 75
ASKER
Adjusted points to 200
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good answer, but the computer was giving students with a 100% score a "F".
I have already receaved an answer from another source, but It would help me if you could help me out with the VB-basics. Conntact me at R_N_WARD@HOTMAIL.COM
I have already receaved an answer from another source, but It would help me if you could help me out with the VB-basics. Conntact me at R_N_WARD@HOTMAIL.COM
All right RN Ward,
I think the remaining problem is that your N21 cell contains the total number of points. It's logic in that case you get an F for 100% score points (the division gives a 1 result, an a 1 was defined in the "noteTable" as F.
Now there are two ways to make this work:
1) Redefine the "noteTable" (no need for doing all steps mentioned above, just do as I say):
Instead of linking your notes to numbers 0 to 9, you redefine the numbers as fractions: 0, 0.1, 0.2,...,0.9
If you want a display in percent, select the fractions, go to Menu Bar/Format/Cells/ Tab Number - Select "Percentage", and look at your sheet.
2) Instead of writing the total number of points in cell N21, you divide this number by ten (10), e.g. for a test of 320 points, write 32 in cell N21
This should help,
Calacuccia
I think the remaining problem is that your N21 cell contains the total number of points. It's logic in that case you get an F for 100% score points (the division gives a 1 result, an a 1 was defined in the "noteTable" as F.
Now there are two ways to make this work:
1) Redefine the "noteTable" (no need for doing all steps mentioned above, just do as I say):
Instead of linking your notes to numbers 0 to 9, you redefine the numbers as fractions: 0, 0.1, 0.2,...,0.9
If you want a display in percent, select the fractions, go to Menu Bar/Format/Cells/ Tab Number - Select "Percentage", and look at your sheet.
2) Instead of writing the total number of points in cell N21, you divide this number by ten (10), e.g. for a test of 320 points, write 32 in cell N21
This should help,
Calacuccia
ASKER