Repeat formula for all cells in whole column

V

Vincent

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
 
J

Jacob Skaria

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Avoiding auxiliary cells 0
Copy addition formula of non-consecutive horizontal cells 2
Cumulative formula for word table 0
Copying formulas across columns 2
Date diffrence in days, weeks and months. 1
countifs Function not giving desired result with date criteria 2
Setting column width in a table with a macro is not working 0
MS Project Center-Autolink column fields 0

Top