Amending an existing function

I sometimes create "if" functions that have several nested statements and I
often find it is easier to first create each "if" function in a separte cell
to make sure each works properly and then add them together to create one big
nested function. I think that I used to be able to copy a function from one
cell and then paste into another cell with an existing function to create one
large nested function but find I can no longer do this. I upgraded to 2003
last fall - could be a setup or difference from 2000. What am I missing?

You should be able to do this from the formula bar. Click in the cell with
the nested (innermost) function, highlight the function (except the = sign)
in the formula bar and copy (ctrl+C). Then click in the parent function's
cell. Go up to the formula bar, click at the point in the formula where the
nested function should be inserted, and paste (ctrl+V).


"Paydog4" wrote:

> I sometimes create "if" functions that have several nested statements and I
> often find it is easier to first create each "if" function in a separte cell
> to make sure each works properly and then add them together to create one big
> nested function. I think that I used to be able to copy a function from one
> cell and then paste into another cell with an existing function to create one
> large nested function but find I can no longer do this. I upgraded to 2003
> last fall - could be a setup or difference from 2000. What am I missing?

Thank you. That seems to work. I think my mistake was that I included the =
sign when copying. Whew! It's the little things that drive you crazy!

"bpeltzer" wrote:

> You should be able to do this from the formula bar. Click in the cell with
> the nested (innermost) function, highlight the function (except the = sign)
> in the formula bar and copy (ctrl+C). Then click in the parent function's
> cell. Go up to the formula bar, click at the point in the formula where the
> nested function should be inserted, and paste (ctrl+V).
>
>
> "Paydog4" wrote:
>
> > I sometimes create "if" functions that have several nested statements and I
> > often find it is easier to first create each "if" function in a separte cell
> > to make sure each works properly and then add them together to create one big
> > nested function. I think that I used to be able to copy a function from one
> > cell and then paste into another cell with an existing function to create one
> > large nested function but find I can no longer do this. I upgraded to 2003
> > last fall - could be a setup or difference from 2000. What am I missing?