cannot copy and paste specific function

[Mary C. Lydon]

I am trying to copy a function from the formaula bar and
paste it to each row and will not work for me. Everytime
I get something pasted it has added the row number, etc.
If I ever get it copied I will then have to change the
specific row numbers to have it work. Each row will have
a different answer as the numbers will be different but
the formula the same.

If anyone can think of a better way please let me know.
Maybe an array. Also, is there anyway once working that
the formauls could be hidden but still work when it runs.

Appreciate any help I can obtain.

Thank you.

Mary C. Lydon

 

[Don Guillett]

using absolutes in the right place will make it happen.
=if(a1=$a$2,1,2)

 

[RagDyer]

On the second part of your question:

Select the cells that contain the formulas that you wish to hide,
Then, <Format> <Cells> <Protection> tab,
Click on "Hidden", then <OK>.

Now, you have to protect the sheet in order for this to take affect.

If this protection inhibits some of the functionality of the sheet, you can
unlock any affected cells beforehand, even the ones that contain the hidden
formulas (means users can replace hidden formula with data entry).
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


using absolutes in the right place will make it happen.
=if(a1=$a$2,1,2)