Function Problems

Excel Formula to Multiply a Value by Month

Elise WilliamsElise Williams Nov 14, 2026 869 views

Question details

Create a formula that multiplies a value by a factor that decreases from 12 in January to 1 in December.

How to Multiply a Value by Month in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet contains a numeric value and a month name or date, and the multiplier should depend on the month.
Observed behavior
The desired result uses a multiplier of 12 for January, 11 for February, and so on, ending with 1 for December.
Before you start

Place the numeric value in A1 and the month name or date in B1. Check whether B1 contains a full English month name as text or an actual Excel date, because each requires a different formula.

Solution 1Recommended

Multiply by month when the month is text

Use MATCH when B1 contains a full English month name, such as January or February.

1
Enter the value and month

Enter the number in A1 and a full English month name, such as January, in B1.

2
Enter the formula

Select C1 and enter =(13-MATCH(B1,{"January","February","March","April","May","June","July","August","September","October","November","December"},0))*A1.

3
Check the result

Press Enter. For example, if A1 is 10 and B1 is January, C1 returns 120.

Multiply by month when the month is text
Use full month names: MATCH looks for an exact month name. Abbreviations, extra spaces, or misspellings can produce an #N/A error.
WPS Spreadsheets

Calculate month-based multipliers in WPS Spreadsheets

Use a MATCH formula in WPS Spreadsheets to multiply a value by a factor based on a month name, then save the workbook in Excel format.

  1. 1. Open a spreadsheet: Open WPS Spreadsheets and create a workbook or open an existing Excel file.
  2. 2. Enter the inputs: Type a numeric value in A1 and a full English month name in B1.
  3. 3. Add the formula: Select C1 and enter =(13-MATCH(B1,{"January","February","March","April","May","June","July","August","September","October","November","December"},0))*A1, then press Enter.
  4. 4. Save the workbook: Choose File > Save As and select XLSX if you want to share the workbook in Excel format.
Calculate a multiplier from 12 in January to 1 in DecemberOpen and save Microsoft Excel XLSX workbooksUse familiar spreadsheet cells and formulas
microsoft office alternative - wps office

Frequently Asked Questions

Why does the formula subtract the month number from 13?

January is month 1, so 13 minus 1 gives 12. December is month 12, so 13 minus 12 gives 1.

Can I use a date instead of a month name?

Yes. If B1 contains an actual date, enter =(13-MONTH(B1))*A1 in C1. The year and day do not change the multiplier.

Why does the MATCH formula return #N/A?

Check B1 for a full English month name that matches the list in the formula. Abbreviations, misspellings, and extra spaces can prevent a match.

How do I apply the formula to other rows?

After entering the formula in C1, drag the fill handle at the bottom-right corner of C1 down the column. The references will adjust to each row.