Convert function to value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to convert a range of cells which currently contain functions
(returning numeric values) to the value returned?

For example:

a1 = 5
a2 = a1 * 2 (returns 10)

How to convert a2 to the number 10, instead of the function?

thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Average problem 1
How to convert a .msg File? 2
copy and paste the cell with formula ="1" 3
Return latest value from data range 4
How to choose maximum value 7
Index / Match / value in a range? 2
Vlookup with If condition 1

Back
Top