# a1a10

1. ### Calculate GPA from Grade List

I am doing admin for a college department. I want to enter the student's grades in A1:A10, for example, and in one cell, to convert those grades to grade points...an A becomes 4.0; a B+ becomes 3.3, etc. I tried doing a vlookup for multiple lookup values. If I do...
2. ### multiply the cells in a dynamic range

a simple question what formula to use to multiply the cells in a dynamic range? e.g. A1:A10 =A1*A2*A3..... *A10 many thanks in advance
3. ### 0.1 increments

In cell B1:B10 I have a value of 100, in cells A1:A10 I have values of 95-104. I need a formula that increases values in B2:B10 by 0.1 until they are equal the cells in A1:A10. Thanks Tim.
4. ### copy cell value down when cell next to it has a value

Hello All, I think this is not as easy as I thought. What I have is a set of values in column A, lets say from A1:A10. Then I have one value in B1 and I want to copy that B1 value down as long as there is a value in A. Column A could be different lengths as in A1:A10 or A1:A1000, it is...
5. ### change by value

I need some help. This would be true for each cell in A1:A10 How do i get this in a VBA code? if(a1:a10=<>,c1:c10="false","true") Thanks for the help!

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back