copying formulas

[excelguy]

I want to copy a formula adding two cells together where one cell always
remains the same, i.e. - C8+$F$8 and then C9+$F$8 and so on until I have
reached C108. Whenever I drag the formula to the next cell the formula add
the next letter instead of the same letter , i.e. - instead of C10+$F$8, it
copies D10$F$8.
I also want to do the same type of formula for F8+$C$8 and it copies F9+$C$8
and so on all the way until F108+$C$8.
I need some help with this. Thanks

 

[Sean Timmons]

Are you trying to drag across? The below would work if you dragged down.

Otherwise, you're trying to invert the data.

You can do that by entering =INDIRECT("$C"&COLUMN())+$F$8

 

[Sninkle]

If you make the formula $C8+$F$8 it will prevent the C from changing to the D.

Out of curiousity what exactly are you doing? Sounds like you are filling a
couple of rows and columns with the same formula?

Carrie

 

[excelguy]

The formula you gave didnt work not sure why.

Im trying to make a table where I can look up a value on the x and y column.
for example, if a student gets a 82 on exam#1 and a 78 on exam#2, his grade
will be something (two values I'm copying from two tables that multiply 1
through 100 by a certain percent). Basically, I want to make a chart so that
people will know what they need to get on the 2 exams to get a certain grade.