How to Calculate Percent Change from the Prior Period in Excel

Open an Excel workbook (.xlsx) in Cue Office. To calculate percent change, subtract the prior count from the current count, then divide by the prior count. This example uses IF to leave the result blank when the prior count is zero. Try it with four community activities.

Why divide by the prior count?

Open the community activity signup sheet. Column B (Prior) is the previous count, Column C (Current) is the current count, and Column D (Change) calculates the rate of change. When the Workshop increases from 100 to 120 attendees, the 20 additional people represent 20% of the prior 100 people.

Activity, Prior, Current and Change columns, with four activities and blank results in D2:D5
Prior and current signup counts are entered in columns B and C, leaving column D for the rate of change.

Enter the formula in D2 and press Enter. C2-B2 is the difference between the two periods, and B2 is the comparison base. This initially returns 0.2.

=IF(B2=0,"",(C2-B2)/B2)
D2 initial calculation displays 0.2, formula bar uses prior period B2 as denominator
D2 calculates 0.2, which will display as 20% after formatting as a percentage.

Select D2:D5, then use Home → Fill → Fill Down to populate the formula down the next three rows. Keep the selection and click the % button on the Home tab. Workshop displays 20%, and Tour drops from 100 to 85 people, displaying -15%.

Fill menu under Home showing Fill Down
Select Fill Down from the Fill menu.
Percentage formatting section and % button
Use the % button on the Home tab to format the selection as percentages.

Why does one row show 0% while another is blank?

The repair activity had 60 signups in each period, so its change is 0%. New club went from 0 to 24. With a prior count of zero, the formula returns an empty string. Select D5 to see the formula in the formula bar. In your recap, report the current count of 24.

In a copy of the sheet, change the workshop’s current count in C2 to 130. D2 updates to 30%. Restore C2 to 120, then change the prior count in B2 to 80. D2 updates to 50%.

Prior B2 temporarily changed to 80, Current C2 is 120, D2 updates to 50%
With 120 signups this period and 80 in the prior period, the change is 50%.

After testing, select each cell you changed, type its original number, and press Enter. In this workbook, restoring the numbers by pasting into individual cells caused them to be saved as text. Save a separate copy after retyping the numbers, then close and reopen it to check both periods and all four results.

Reopening manual final version, Column D shows 20%, -15%, 0%, and blank, with formula still in D5 formula bar
Reopening the manual final version shows 20%, -15%, and 0% in the first three rows, leaving the last row blank.

How do you ask Cue AI to fill four rows and handle a zero prior count?

Open a copy of the signup sheet where the rate of change has not yet been filled. Click Cue AI on the toolbar, and specify which number to use as the base, which four cells to populate, and when to leave the result blank.

Cue AI toolbar button with the open Cue AI pane below it
Open Cue AI in the initial signup sheet copy.
How much did signups change compared with the prior period for each activity? Fill D2 through D5 with formulas that use the prior signup count as the comparison base. Display the results as percentages with no decimal places. If the prior count is zero, leave the result visually blank. Keep the headings and signup counts as they are.

After Cue AI fills the cells, test the result in the copy. Change New club’s prior count in B5 from 0 to 12. The current count stays at 24, and D5 updates from blank to 100%.

AI-generated D5 displays 100% after temporarily changing Prior B5 to 12
Temporarily changing the New club prior count to 12 immediately causes D5 to display 100%.

Type the number 0 back into B5 and press Enter. Save a separate AI copy, then close and reopen it. Check that the headings and signup counts match the original and that the first three results are 20%, −15%, and 0%. Select the blank-looking D5 and check that its formula is still in the formula bar.

AI final version reopened, first three rows show correct percentages, D5 is blank with calculation formula visible in formula bar
After restoring the prior count to number 0, reopening the AI final version displays a blank cell with the formula still intact in D5.

Practice with four community activity records

Show the full example

Set up the data starting at A1. Put the activity names in column A, enter the prior and current counts as numbers in columns B and C, and leave D2:D5 blank. Return to the first formula.

Activity	Prior	Current	Change
Workshop	100	120
Tour	100	85
Repair	60	60
New club	0	24

Review signups by looking at counts and percentage change together

After the next signup period, ask Cue AI to recalculate each activity’s change using the latest two periods. Tell the event lead that the workshop gained 20 signups, a 20% increase. Report the new club’s 24 signups separately. Before adjusting tour sessions, check the drop from 100 to 85 with the colleague who keeps the sign-in records.

Use the Excel signup tracker (.xlsx) in Cue Office to keep both periods’ counts and record proposed tour changes in a Word recap (.docx). In the PowerPoint briefing (.pptx), show first-time activities separately. Check dates and locations against the original event schedule (.pdf). Spreadsheets, documents, and presentations are free to edit, and PDFs are free to read.

Download Cue Office for free