I have 25 columns of over 1500 pieces of data each. Each column needs to use a different variation of one equation in which the number in the cell needs to be multiplied by another number. How can I set it up so that every cell in a column is multiplied by one constant?
2007-02-18 10:20:00 · 2 answers · asked by usfbabe85 1 in Computers & Internet ➔ Software
Put the constant into another worksheet or somewhere on that worksheet and then reference that area as a static cell.
For example,
=a1*a2*$Z$1
this will multiply A1 * A2 and then multiply by Z1. When you copy the formula down (or across) the page, the $Z$1 portion does not change and will always reference Z1.
2007-02-18 10:39:04 · answer #1 · answered by BigRez 6 · 1⤊ 0⤋
that can be done..
why dont u message me at herochenna@yahoo.com i can help u on that instantly..
if u dont have a yahoo messenger or dont find me online..
just visit this site... www.excelgodies.com there are many excel consultants who are online.. who can help u on this..
2007-02-19 08:42:29 · answer #2 · answered by Anonymous · 0⤊ 0⤋