Hello,
I have one formula for a column and 100 rows. The formula takes data from several different column cells on the same row. If i want to use the same formula for that colomn on every row, is there a way to have it automatically change the formula row to row without manually doing it. i.e. 1st row formula is: =(G1-G1*H1)*J-325 - 2nd row formula is: =(G2-G2*H2)*J-325 Do i have to change the formula for each row or is there formula that does this?
Configuration: Windows XP Internet Explorer 8.0