Click a cell in the array formula. To calculate the percentage change between two values in Excel you can use a formula that divides the difference between two values by the old value. Replace formulas with their calculated values.
Youre trying to edit an array formula and youre stopped in your tracks.
Click Evaluate multiple times. If youve entered a single-cell array formula select the cell press F2 make your changes and then press CtrlShiftEnter. Step 1 Type in a series of names or text in a column in your worksheet. These are the functions we can use in any worksheet in Excel.