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?

Amending an existing function
 

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?

Amending an existing function
 

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?