View Single Post
  #4   Report Post  
Niek Otten
 
Posts: n/a
Default

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.