ExcelBanter - How do I copy a result without copying the formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I copy a result without copying the formula? (https://www.excelbanter.com/excel-discussion-misc-queries/11206-how-do-i-copy-result-without-copying-formula.html)

riffmastr7

How do I copy a result without copying the formula?

Let's say I got a result of 216 in cell A1. I want to use that same result in
A1 to another calculation without copying the formula. How do I do it?

Myrna Larson

What have you tried? To use that result in another formula, you write A1
instead of a number, i.e. something like

=A1+23

On Wed, 2 Feb 2005 10:51:02 -0800, "riffmastr7"
wrote:

Let's say I got a result of 216 in cell A1. I want to use that same result in
A1 to another calculation without copying the formula. How do I do it?

All times are GMT +1. The time now is 09:06 AM.