Auto Fill (within formula)

[yitzymerm]

I have the following formula on 1 cell =IF(J$6>2,J$5,"$0.00"), and I want to drag it down so that excel should auto fill just this part >2, that the cell below should be >3 and the one after >4 and so on, but instead when i drag it down excel copies everything the same as >2, and to change this manually each cell is very time consuming...

Thanks who ever can help.

 

[Sufiyan97]

Hi
Welcome to MrExcel.

Do you want it like??

=IF(J$6>2,J$5,"$0.00")
=IF(J$6>3,J$5,"$0.00")
=IF(J$6>4,J$5,"$0.00")

 

[Fluff]

Hi & welcome to MrExcel.
Is this what you mean?

Fluff.xlsm
	I	J
5		0.5
6	0.5	5
7	0.5
8	0.5
9	$0.00
10	$0.00
11	$0.00
Data Dump

Cell Formulas
Range	Formula
I6:I11	I6	=IF(J$6>ROWS(J$5:J6),J$5,"$0.00")

 

[yitzymerm]

Hi
Welcome to MrExcel.

Do you want it like??

=IF(J$6>2,J$5,"$0.00")
=IF(J$6>3,J$5,"$0.00")
=IF(J$6>4,J$5,"$0.00")

Yes please

 

[Fluff]

In that case see post#3

 

[yitzymerm]

Thanks guys for your help, took me some time to figure out your answer but realized afterwards it's because I started the table in middle the sheet so i had to change instead of 'rows' to 'values' and have one column of my table with numbers 1 and up....

 

[Fluff]

Glad we could help & thanks for the feedback.