when i copy a formula to a range of cells the formula logically
changes according to the other cells. However, i need to maintain the
very same formula throughout the range of cells . i am able to
successfully paste the same formula to a single cell, but not to a
range of cells.