Share via

How to copy formula into nested function

Anonymous
2022-02-15T10:30:22+00:00

Hello

I have a problem with nested functions. I have two functions in separate cells and I want to copy their syntax into active cell of third function to create nested function. But every time I try to to do it I get only the reference to the other sheet which formula in that cell is using to its calculations.

How can I copy formula from other cell when constructing a nested function?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2022-02-15T11:03:06+00:00

Select one of the two cells.

Click in the formula bar.

Select the formula without the = at the beginning.

Press Ctrl+C to copy the selection.

Select the third cell.

Click in the formula bar.

Place the insertion point where you want to paste the formula that you copied.

Press Ctrl+V to paste.

Repeat for the other of the two cells.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-02-15T11:14:41+00:00

    Thank you Hans, removing = and adding it only after nested function was complete did the trick.

    Was this answer helpful?

    0 comments