starsky
02-25-2011, 01:28 PM
Hi,
I'm working on a different pc to usual. I'm trying to pull a formula down a column to apply a simple multiplication formula (of the 2 columns to the left), but I'm getting the same result in each cell even though different values appear on each row. E.g. in C2 formula might be A2*B2 with result of '10'. If I pull this down I will have the correct formula in C3, but the result will be '10' again, even though that is the incorrect answer.
I am bemused to say the least.
Any ideas?
Thanks
I'm working on a different pc to usual. I'm trying to pull a formula down a column to apply a simple multiplication formula (of the 2 columns to the left), but I'm getting the same result in each cell even though different values appear on each row. E.g. in C2 formula might be A2*B2 with result of '10'. If I pull this down I will have the correct formula in C3, but the result will be '10' again, even though that is the incorrect answer.
I am bemused to say the least.
Any ideas?
Thanks