Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I use a circular function to add 4 to a column of cells?
I'm using excel for my gradebook & would like to use this function to curve
scores. |
#2
|
|||
|
|||
Hi Tricia,
I think you'll have to elaborate quite a bit more on what you're trying to achieve, if you want to get any help. Kind regards, Niek Otten "Tricia" wrote in message ... I'm using excel for my gradebook & would like to use this function to curve scores. |
#3
|
|||
|
|||
OK-
I have a column of test grades and what I want to do is add 4 to each grade in the column. So, for instance if I have the number 80 in U5, I want to be able to say U5+4 and have it return the number 84. Then I want to copy the function to the entire column. "Niek Otten" wrote: Hi Tricia, I think you'll have to elaborate quite a bit more on what you're trying to achieve, if you want to get any help. Kind regards, Niek Otten "Tricia" wrote in message ... I'm using excel for my gradebook & would like to use this function to curve scores. |
#4
|
|||
|
|||
Format an empty cell as number. Enter the number 4. EditCopy
Select your numbers. EditPaste special, check Add Kind regards, Niek Otten "Tricia" wrote in message ... OK- I have a column of test grades and what I want to do is add 4 to each grade in the column. So, for instance if I have the number 80 in U5, I want to be able to say U5+4 and have it return the number 84. Then I want to copy the function to the entire column. "Niek Otten" wrote: Hi Tricia, I think you'll have to elaborate quite a bit more on what you're trying to achieve, if you want to get any help. Kind regards, Niek Otten "Tricia" wrote in message ... I'm using excel for my gradebook & would like to use this function to curve scores. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |