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

if(relatedcell="","",relatedcellformula)

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Steve Fletcher" <(E-Mail Removed)> wrote in message
news:Oqetb.63$(E-Mail Removed)...
> 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



On Sat, 15 Nov 2003 00:28:31 -0000, "Steve Fletcher"
<(E-Mail Removed)> wrote:

>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
>