About a cell containing Functions

[The AD]

Hello
I have to face a problem, while I tried to copy a cell containing formula or functions, to an other cell, i.e

let cell A2 contains a formula "=(C2*2)+(D2*3)"
while C2=7.5 and
D2=11.25
Question is that how can I past A2 to other cell as
"=(7.5*2)+(11.25*3)" ?
when I paste it as values, it becomes 48.75
when I paste it as formula, it becomes "=(C2*2)+(D2*3)"
awaiting a best solution from you

AD

[MickG]

Hi, To copy the formula exactly, I Double click the formula, to expose the Formula, then select the entire formula. (Selection turns Black), then with the cursor still on the cell, click return ( Formula returns to a value), Then paste the formula to a new cell.
Regards Mick

[Richard Schollar]

I think you'd have to use select the formula in the formula bar and highlight each cell reference and hit F9 to convert to a value, then select the entire formula and do a Ctrl+C to copy then escape out of the cell (to return it to a formula) then click on the destination cell, hit F2 and paste (Ctrl+V). Which is kinda longwinded. You could use VBA instead.

Richard

[The AD]

I think you'd have to use select the formula in the formula bar and highlight each cell reference and hit F9 to convert to a value .......
Richard

It is not problem for one cell, but for 1500 cells it becomes very lengthy procedure. I want solution of this problem, for more than one cells only.
I hope you will give useful tips in this concerning.
Regard,
AD

[Richard Schollar]

I think I'm right in saying what you are asking for is actually failry complicated - what result would youy want where the formula included a range eg:

=SUM(A1:A10)

or

=VLOOKUP(A1,B10:H100,3,0)

?

[Andy Pope]

If the cells all contain formula as per you example then you could parse and evaluate the formula with some simple code.

If your cells contain complex formula then the parsing will become much more difficult and even the processing of each cell may be quicker than coding a robust algorithm.

Please Login or Register  to view this content.

[The AD]

If the cells all contain formula as per you example then you could parse and evaluate the formula with some simple code.

If your cells contain complex formula then the parsing will become much more difficult and even the processing of each cell may be quicker than coding a robust algorithm.

Please Login or Register  to view this content.

A good approach!

Thanks
AD