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

Excel VBA 1
Copying formulas across columns 2
countifs Function not giving desired result with date criteria 2
One Formula Referenced In Many Cells 6
How to use autofilter in excel with formula reference changing 1
Excel - IF formula with range of cells 2
Display formula with values referenced 3
Scrabble Value calculation for Welsh words 0

Top