View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vincent Vincent is offline
external usenet poster
 
Posts: 39
Default 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