Hi, I am quite new to VB in Excel.
I would like to write a function which converts any given percentage into a grade following the grade system defined (this would vary depending on class so would I define table first?)
I have tried mathematically working this out using ratios/percentages but could not think of a straightforward method to do this...
Would appreciate any ideas.
Sample conversion rates:
0 - 0%
1.0 - 45%
1.6 - 65%
2.3 - 75%
3.1 - 85%
3.7 - 100%
I would like to write a function which converts any given percentage into a grade following the grade system defined (this would vary depending on class so would I define table first?)
I have tried mathematically working this out using ratios/percentages but could not think of a straightforward method to do this...
Would appreciate any ideas.
Sample conversion rates:
0 - 0%
1.0 - 45%
1.6 - 65%
2.3 - 75%
3.1 - 85%
3.7 - 100%