copy formula only

  • Thread starter Thread starter Steve Fletcher
  • Start date Start date
S

Steve Fletcher

When I copy a formula down the column the value gets repeated all the way
down too . How can I only paste the formula so as the cells stay blank
until related cells are filled in to make the calculations.
Thanks
Steve
 
Steve

Example only, your data and formulas will differ.

Columns A has numeric data. Column B is blank but awaiting data.

You want the product of A1 and B1 and on down the columns.

In C1 enter =IF(B1="","",A1*B1) then drag/copy down Column C

The idea is to have a qualifier in the formula. If a certain parameter is not
met, then leave C looking blank otherwise show the results of the calculation.

If you have a particular formula you need help with, post it.

Gord Dibben XL2002
 
You must log in or register to reply here.

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

Copy formula 6
Formula to fill cells based on Date of Arrival and Date of Departure 1
How to set cell value to emptry if three other columns are empty too 1
Column of formulas with some cells containing data derived from thereformula's I would like to find 2
Excel VBA 1
Turning value of formula into actual cell content? 1
adding rows into the table 1
Copy formula help 2

Back
Top