Replace formula with value automatically.

  • Thread starter Thread starter datakman
  • Start date Start date
D

datakman

Looking to find a way to replace a formula with its value after the value is
determined. Would prefer not to go into COPY+PASTE+VALUE to make this
happen. Is there a command or string that will make this happen?
 
Hi,

Not really anything that does exactly what you want, but here are three
options:

1. Select the formula on the Formula Bar and press F9, Enter
2. Select the cell directly below the formula and press Ctrl+" (control
double quotes)
3. Use a macro

Sub ConvertToValues()
Selection = Selection.Value
End Sub
 
You have to excuse me. This is the first time I have used this type of help.
As you can see, I submitted the question twice. I couldn't find this
location so I didn't know where the question went to.

I know how the work the CTR+C, CTR+V. Didn't know about ALT+E.

What I want to accomplish is through an IF statement:
If a cell has a number in it, say anything >0, replace the formula cell with
the calculated value or leave as is.
 
Back
Top