I want to know how to copy a formula into another, while keeping the original values. For instance, I have in range A1:A5
five values (a mix of constants and/or formulas) and I need (in that same range – not in a new column) to include function =Round("original value or formula",2)
, (or any other formula; this is just an example)
For example:
A1
original value50.64635
A2
original formula=3*F1
(which may display as54.25875
ifF1
contains18.08625
)A3
original formula=SQRT(2)
(which will display as1.4142136
)
Result I want is:
A1
new content (formula)=round(50.64635,2)
A2
new content (formula)=round(3*F1,2)
A3
new content (formula)=round(SQRT(2),2)
etc.
Note that I do not want A1
to be changed to 50.65
,
and I do not want A2
to be changed to 54.26
or even =ROUND(54.25875,2)
, etc.
I know how to do similar things with simple operations (copy/paste special – Formula – add, substract, multiply, divide
) and keep original values or formulas. But I don't know how to wrap a function around an existing value
or otherwise build a formula, using an existing formula as a component.
The other idea would be to play converting my original values/formulas to text, use find/replace function, concatenate, or some weird mix and I would come to result I want, but I would like to know if there is some shorter way ;)