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.
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)
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%.
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%.
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.
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.
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%.
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.
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.