To do this click in the cell with the formula and select the part of the formula you want to convert to a static value and press F9. If you have Kutools for Excel its Displayed To Actual tool can help you quickly convert the value or. There are three shortcuts Excel Shortcuts PC Mac Excel Shortcuts - List of the most important common MS Excel shortcuts for PC Mac users finance accounting professions.
RngFormula rngValue First you need to add the module into the workbook or the add-in file.
If you need to change the content on the cell that has some value in it youll need to use. Select cell B3 to make it the active cell. The Excel IF function will work if the logical_test returns a numeric value. Click the cell that contains the formula.