a1a10

  1. D

    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. A

    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. T

    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. F

    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. R

    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!

Watch MrExcel Video

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top