# How to fix the Column's value in a formula?

#### sulphox

##### New Member
Hi all,

I would like to ask regarding the Non-vary column in excel.

Let's say i have the following formula in column B
=0.5-0.5*(COS(2*PI()*(A61/A65+1)))

Is there a way to vary A61 from row to row while fixed A65
that is i want to have the following results
=0.5-0.5*(COS(2*PI()*(A2/A65+1)))
=0.5-0.5*(COS(2*PI()*(A3/A65+1)))
=0.5-0.5*(COS(2*PI()*(A4/A65+1)))
.......
=0.5-0.5*(COS(2*PI()*(A65/A65+1)))

Where A2, A3, A4, ..., A65 are all constant value in column A.
A2 is the 1st constant value and A65 is the last constant value.
in short, even if i change values in column A,
the denominator in the formula in column B has to be "last constant value+1"

I tried to copy and paste but it did not work.

I ended up getting results like
=0.5-0.5*(COS(2*PI()*(A2/A2+1)))
=0.5-0.5*(COS(2*PI()*(A3/A3+1)))
=0.5-0.5*(COS(2*PI()*(A4/A4+1)))
.....
=0.5-0.5*(COS(2*PI()*(A65/A65+1)))

Sulphox

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Try \$a\$65

Replies
5
Views
98
Replies
0
Views
219
Replies
5
Views
80
Replies
9
Views
78
Replies
3
Views
180