📊 Spreadsheet Guide

CPM Formula
Excel — Ready
to Use Formulas

The exact CPM formula Excel syntax for calculating CPM, cost, and impressions in your spreadsheet — plus a free online CPM calculator if you prefer to skip the manual setup.

▶ Get Excel Formulas Use Calculator ↓

$ Free CPM Calculator

$
Your CPM
–
Ready to Copy

CPM Formula Excel — All 3 Variants

Copy these CPM Excel formulas directly into your spreadsheet. Each formula assumes your data starts in row 2 with headers in row 1.

📐 Calculate CPM

=(B2/C2)*1000

B2 = Total Cost  |  C2 = Impressions

With error protection: =IFERROR((B2/C2)*1000,0)

💰 Calculate Cost

=(B2*C2)/1000

B2 = CPM Rate  |  C2 = Impressions

With error protection: =IFERROR((B2*C2)/1000,0)

👁️ Calculate Impressions

=(B2/C2)*1000

B2 = Budget  |  C2 = CPM Rate

With error protection: =IFERROR((B2/C2)*1000,0)
Complete Guide

CPM Excel Formula — Full Guide

Everything you need to build a working CPM tracker in Excel or Google Sheets using the CPM formula Excel syntax.

The CPM formula Excel is straightforward because Excel handles the math automatically once you enter the formula correctly. The core CPM Excel formula is =(B2/C2)*1000 — divide your cost by impressions and multiply by 1,000. The result is your CPM. Enter this in a dedicated CPM column and drag it down to apply to as many rows as needed.

Setting Up Your CPM Spreadsheet

To build a proper CPM tracker using the CPM formula Excel syntax, start with these column headers in row 1: Campaign Name in A1, Budget in B1, Impressions in C1, CPM in D1. In D2, enter the CPM formula Excel: =(B2/C2)*1000. Format column D as currency with 2 decimal places. Now drag D2 down to fill as many rows as your campaign list requires.

This setup lets you paste campaign data from Facebook Ads Manager, Google Ads, or TikTok Ads Manager directly into columns B and C, and your CPM Excel formula calculates the rate automatically for every row. No manual calculation needed.

CPM Excel Formula — Error Handling

The most common issue with the CPM formula Excel is the #DIV/0! error that appears when the impressions cell is empty or zero. Wrap your CPM Excel formula in IFERROR to handle this cleanly: =IFERROR((B2/C2)*1000, 0). This returns 0 instead of an error when impressions data is missing, keeping your spreadsheet looking clean during data entry.

CPM Excel Formula for Multi-Platform Tracking

If you track campaigns across multiple platforms, add a Platform column (E1) and use conditional formatting to color-code CPM values. Apply a green fill for CPM below your target rate and red fill for CPM above it using Excel's Highlight Cell Rules. The CPM formula Excel handles the calculation the same way regardless of the platform — the formula doesn't change, only the data does.

CPM Excel Formula vs Google Sheets

The CPM formula Excel syntax is identical in Google Sheets. The formula =(B2/C2)*1000 works exactly the same way in both applications. If you share your CPM tracker with team members who use Google Sheets, they can open the file and the CPM Excel formula will function correctly without any modification. This cross-compatibility makes the CPM formula Excel one of the most portable spreadsheet tools in digital marketing.

Building a CPM Dashboard in Excel

Once your CPM formula Excel is running across multiple rows, you can add summary statistics at the top of the sheet. Use =AVERAGE(D2:D100) to calculate your average CPM across all campaigns. Use =MIN(D2:D100) and =MAX(D2:D100) to find your best and worst performing campaigns by CPM. Add a simple bar chart from the CPM column to visualize performance trends across your portfolio at a glance.

📊 CPM Excel Formula Reference
CPM = =(B2/C2)*1000
Cost = =(B2*C2)/1000
Impressions = =(B2/C2)*1000

Column Setup:

A = Campaign Name
B = Cost / CPM / Budget
C = Impressions / Impressions / CPM
D = CPM result formula

Average CPM across campaigns:
=AVERAGE(D2:D100)

Best CPM (lowest):
=MIN(D2:D100)
Common Questions

CPM Formula Excel — FAQ

Answers to the most common questions about the CPM formula in Excel and Google Sheets.

The CPM formula in Excel is =(B2/C2)*1000 where B2 contains Total Cost and C2 contains Total Impressions. This CPM Excel formula calculates Cost Per Mille automatically. To protect against division errors when cells are empty, use the safer version: =IFERROR((B2/C2)*1000,0).
To calculate impressions from CPM in Excel: =(B2/C2)*1000 where B2 is your budget and C2 is your CPM rate. For example, a $500 budget at $5 CPM gives 100,000 impressions. This is the impressions variant of the CPM Excel formula — the same syntax, different input values.
To calculate cost from CPM in Excel: =(B2*C2)/1000 where B2 is your CPM rate and C2 is your target impressions. For example, $5 CPM and 200,000 impressions gives a cost of $1,000. This cost variant of the CPM formula Excel uses multiplication instead of division.
Yes, the CPM formula Excel syntax is identical in Google Sheets. The formula =(B2/C2)*1000 works exactly the same way in both platforms. No adjustments are needed when copying CPM Excel formulas into Google Sheets — full cross-compatibility is guaranteed.
To build a CPM tracker in Excel: create columns for Campaign Name (A), Budget (B), Impressions (C), and CPM (D). In D2, enter the CPM formula Excel: =(B2/C2)*1000. Drag D2 down for all rows. Add =AVERAGE(D2:D100) above the data for an overall CPM summary. Use conditional formatting to highlight campaigns above or below your target CPM threshold.