Hi folks,

I don't know if this is an approppriate forum for this type of question but, anyway here it is.

I have an Excel spreadsheet with a set of numbers in the range A5:A200 and another set of numbers in the range B5:B200. Then there's a formula in the range C5:C200 that squares all the numbers in the first column: A5*A5 in cell C5, A6*A6 in cell C6 and so on.

Then I have an indexer number in cell A1. It can be 0 or 1. I want to change the formula in column C such that, if A1's contents is 0 then the formulas are A5*A5, A6*A6, etc and if the contents of A1 is 1, then the formulas in column C are B5*B5, B6*B6, etc. Of course, once I have the correct formula in C5 then I want to drag over the rest of the column.