# Take a value, divide by X, Apply the quotient across X number of Columns

#### chloec

##### Member
Hi Geniuses,
I am looking for a formula to do the following:

1. Take a value ((\$100, for example))
2. Divide by X ((4, for example))
3. Apply the quotient ((25)) across X # ((4)) of Columns starting at a particular column as noted by Month and Year

- If a column is NOT relevant, it should be blank. I may extend the month and year combos in any direction (Months 2022 through Months 2025, for example)
- I want to be able to edit values in A2 - C2 and have this formula auto-populate (for exmple, change the value, Divisor or date or any combination)

Visual:
Header RowA1
Value
 B1
Divisor
 C1
Date
D1
Aug 2024
E1
Sept 2024
F1
Oct 2024
G1
Nov 2024
H1
Dev 2024
I1
Jan 2025
Data Row1004Sept 202425252525

Thank you!

say in cell D4:
=IF((\$D\$1:\$P\$1>=C4)*(\$D\$1:\$P\$1<=EDATE(C4,B4-1)),A4/B4,"")
copy up/down

This is PERFECT! This is amazing, you are amazing. Thank you @p45cal

Last edited: