-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
a1a10
-
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...- DrDebit
- Thread
- a1a10 array grade grades vlookup
- Replies: 4
- Forum: Excel Questions
-
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- AlanY
- Thread
- a1a10 cells dynamic multiply range
- Replies: 3
- Forum: Excel Questions
-
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.- Tlord
- Thread
- a1a10 b2b10 cells tim values
- Replies: 5
- Forum: Excel Questions
-
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...- frankandsteph
- Thread
- a1a10 a1a1000 cell column copy
- Replies: 9
- Forum: Excel Questions
-
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!- rspalding
- Thread
- a1a10 c1c10=false code ifa1a10= vba
- Replies: 8
- Forum: Excel Questions
