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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 09:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com