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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Format an empty cell as number. Enter the number 4. Edit>Copy
Select your numbers. Edit>Paste special, check Add

Kind regards,

Niek Otten
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Circular reference, Indirect, and Sum 3
How do I locate a circular formula? 2
Ties using Rank Function 3
Excel Applying Code to a Column 0
a cell contain formula, how to extract value of that cell 1
Circular 7
need help printing rows & headers w/macro 4
How to SUM entire column, but only when adjacent cell is not empty 3

Back
Top