How can I use a circular function to add 4 to a column of cells?

N

Niek Otten

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
 
T

Tricia

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

Niek Otten

Format an empty cell as number. Enter the number 4. Edit>Copy
Select your numbers. Edit>Paste special, check Add

Kind regards,

Niek Otten
 
Top