for next loop calculating percentages grades

[mbababrik]

Students assignement1 assignement2.. blank clmn total(%)
a 12 9 5
b 15 6 4
max pt on *** 20 10 5
i want to write a code that would calculate the % grade of each student and report it on the last colum knowin that the column before it is blank.
theres more assignements on the real worksheet and more students. assume that the last row contains the max pts possible for the assignement. remember that the grades given are numeric. i also want to ask the user using a textbox how many asignement is there and where the data starts from. Assume each blank cell is a zero.
plzzz any help will be appreciated
thank you

 

[hiker95]

mbababrik,

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples directly in the forum.

Two reasons:
- helpers don't have to spend extra time tracking to other sites to find your samples.
- you can post samples here where helpers can copy your sample data to their own test worksheets. Most of us don't like manually typing sample data!

Here are three possible ways to post small (copyable) screen shots directly in your post:

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

or
RichardSchollar’s beta HTML Maker -...his signature block at the bottom of his post

or
Borders-Copy-Paste


Or, you can upload your workbook to www.box.net and provide us with a link to your workbook.