This overwrites the formulas with the values they return. The Excel AND function is a logical function used to require more than one condition at the same time. The same calculation can be done by using excel simple formulas.
With more than 300 handy Excel add-ins free to try with no limitation in 30 days.
Here are the steps to show formulas in Excel instead of the value. In the Formula Auditing group click on the Show Formulas option. The percent change formula is used very often in Excel. Then press Enter key and select cell D1 drag the fill handle to the range which you want to apply this formula.