help with use of excel?

Question

i compute grades using excel and i know the IF conditioons goes only for seven continuous logic conditions..and i'll be needing the visual basic editor..problem is i do not know how and what to type on the code window of visual basic editor. You have to type something first and create something first right?...i want to use the Select Case Statements instead in the visual basic editor...help

i just want to know how to use vb editor in msexcel..i know how to construct the select case statements...what i need is the instruction on how to use the vb editor....

Answer 1

If you post specifics of how your spreadsheet is set up and how you want calculations to run, many here can help you with specific code to make it happen.

Meanwhile, here's some general tips:

Suppose you have five grades for child x listed in cells A1, B1, C1, D1, and E1. in F1 you can put an autosum for those 5 grades. In G1 you can put =(F1/5) for an average score.

Then your SELECT looks something like:

SELECT CASE G1
Case = 80
H1 = "B"
Case = 90
H1 = "A"
END SELECT

You'll want to work with ranges (80 - 89) instead of single numbers, but hopefully that gets you started

Answer 2

I found this link as a starting point.

You will now have to read all the grades in a column and re-calculate all new grades.