if (column range; eg, A8:A42) has any value, then Copy a cell (formula; in C2) two columns to the right of every cell in that column (A) that has a value.
Complicated, I think.
Basically, I have a cell with a formula. In column A, I need to manually input some findings. Not every cell in Row A is going to have input. But, for the ones that do have input, I want it to copy a formula to a cell in the same row, but 2 columns to the right.
I'm familiar with the RC stuff, and formulation, but not when it contains 3 parties and an if/then statement. Any help would be appreciated.