SOLVED

autofill pattern

Copper Contributor

How can I autofill a column with several hundred lines like this...The only difference is C2, C3, C4, etc....

 

=IFERROR(C1*C2,"$0.00")
=IFERROR(C1*C3,"$0.00")
=IFERROR(C1*C4,"$0.00")
=IFERROR(C1*C5,"$0.00")
=IFERROR(C1*C6,"$0.00")

 

Windows 10 Pro

Microsoft® Excel® for Microsoft 365 MSO (16.0.14228.20216) 64-bit

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@DataLife 

Change the first formula to

 

=IFERROR(C$1*C2,"$0.00")

 

The $ before the row number makes that row number absolute (fixed).

Then fill or copy down.

@Hans Vogelaar 

 

fantastic! It works, thanks

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@DataLife 

Change the first formula to

 

=IFERROR(C$1*C2,"$0.00")

 

The $ before the row number makes that row number absolute (fixed).

Then fill or copy down.

View solution in original post