Formula Help Needed

[akvpv6]

I am struggling to find the right formula that can carry over into the row of cells by month. In the image I uploaded I am looking for a formula that will divide the data in C5 by the data in C6 but also carry that formula to D5/D6 through N5/N6.

I would like to keep the formatting the same where if there is no data present then the cells from C4-N4 remain empty.

I appreciate any help you can provide!

 

[awoohaw]

something like htis:

Book2
	C	D	E	F	G	H	I	J	K	L	M	N
1
2	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar
3	25%	25%	25%	50%	50%	50%	75%	75%	75%	85%	85%	85%
4	27%	33%	36%	30%	32%	28%	37%	35%	28%	47%	47%	41%
5	20	25	26	25	23	23	31	31	24	37	40	34
6	74	75	72	84	71	81	83	89	87	79	86	82
Sheet2

Cell Formulas
Range	Formula
C4:N4	C4	=C5/C6

 

[awoohaw]

or this in just one cell

=C5:N5/C6:N6

 

[Fluff]

Another option

=IF((C5:N5="")+(C6:N6=""),"",C5:N5/C6:N6)

 

[akvpv6]

something like htis:

Book2
	C	D	E	F	G	H	I	J	K	L	M	N
1
2	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar
3	25%	25%	25%	50%	50%	50%	75%	75%	75%	85%	85%	85%
4	27%	33%	36%	30%	32%	28%	37%	35%	28%	47%	47%	41%
5	20	25	26	25	23	23	31	31	24	37	40	34
6	74	75	72	84	71	81	83	89	87	79	86	82
Sheet2

Cell Formulas
Range	Formula
C4:N4	C4	=C5/C6

I originally was using C5/C6 but I am trying to use a formula that will auto populate the percentage after I manually add in the data for rows 5 and 6.

Another option

=IF((C5:N5="")+(C6:N6=""),"",C5:N5/C6:N6)

This one seems to be working exactly how I needed it to, thank you for the quick help!

 

[Fluff]

Glad we could help & thanks for the feedback.