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

sulphox

New Member
Joined
Nov 23, 2005
Messages
5
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)))


Thanks in advance

Sulphox
 

Some videos you may like

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

Watch MrExcel Video

Forum statistics

Threads
1,118,911
Messages
5,575,001
Members
412,633
Latest member
simon_elvin
Top