excel to CSV
Brief tutorial to convert Excel file to CSV file.
Sample Student Marks with grade calculation data
To calculate the grade I am not using any macro, rather a simple formula is used:
=IF(H2 condn 90,"O",IF(H2 condn 80,"E",IF(H2 condn 70,"A",IF(H2 condn 60,"B","F"))))
where H2 is the cell address contains the percentage of marks; and condn I am using 'greater_than_or_equal_to'