Hey
I have a quick question, I have this excel ark where there is a column that has the following code:
q1 = 1/2 * x1 * y1q2 = 1/2 * x2 * y2 + x1 * y1q3 = 1/2 * x3 * y3 + x2 * y2 + x1 * y1q4 = 1/2.............
and so on and so on.
How do I program this smart? I've tried to make a for loop, but I can't figure out how the make the 1/2 only stick to the new x-y values and not the others.
Best Answer