Copy and paste formula only if the cell is non-blank

[cabybake]

Hi all,
I am trying to set up a column where a formula is copied and pasted
into the next cell only if the cell goes from blank to non-blank.
The formula relies on the cell above it added to a cell in another
location. Is this possible without VB? Thanks, cabybake

[Don Guillett]

without vb(a) you would have to
=if(a1="","",a1+c44)

--
Don Guillett
SalesAid Software
donaldb@281.com
"cabybake" <cabybake@yahoo.com> wrote in message
news:1107798087.974865.104880@g14g2000cwa.googlegroups.com...
> Hi all,
> I am trying to set up a column where a formula is copied and pasted
> into the next cell only if the cell goes from blank to non-blank.
> The formula relies on the cell above it added to a cell in another
> location. Is this possible without VB? Thanks, cabybake
>