Repeat formula for all cells in whole column
 

In C1, I have a formula to calculate the result of A1 and B1. This same
formula is to be repeated on all the subsequent rows ie C2 calculates result
of A2 and B2 and so on. Instead of copying the formula on every single cell
of Column C, is there a way that the formula is coded for the entire column
C cells and whenever values are entered into cells of Column A and B, the
result is then displayed in Column C. If no values are in the cells of
Column A and B, then cells in Column C is Blank.
Thanks

Repeat formula for all cells in whole column
 

--Copy the below formula to C1
=IF(COUNT(A1,B1)=2,A1*B1,"")
--Copy cell C1
--Keeping the copy; select Column C.
--Right click PasteSpecialselect Formulas click OK

If this post helps click Yes
---------------
Jacob Skaria


"Vincent" wrote:

In C1, I have a formula to calculate the result of A1 and B1. This same
formula is to be repeated on all the subsequent rows ie C2 calculates result
of A2 and B2 and so on. Instead of copying the formula on every single cell
of Column C, is there a way that the formula is coded for the entire column
C cells and whenever values are entered into cells of Column A and B, the
result is then displayed in Column C. If no values are in the cells of
Column A and B, then cells in Column C is Blank.
Thanks