The original formula as created by Gleicher and published by Richard Beckhard see Attribution confusion below is. Paste Values with a Simple Keyboard Shortcut. And the third using the ribbon shortcuts via Alt H requires the most keystrokes.
Below is a complete guide of how to use each approach to make formulas into values.
The Find and Replace action will now be applied to cell range B3B4. We can write a formula to multiply the cells value by negative 1 -1. Divide that change by the old value you will get a decimal number Step 3. Formula to Calculate Percentage Change Percentage Change can be defined as a change in value due to changes in the old number and new number and the values can either increase or decrease and so the change can be a positive value or a negative value -.