Aug 17 2021 02:29 PM
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
Aug 17 2021 02:59 PM
SolutionChange 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.
Aug 17 2021 02:59 PM
SolutionChange 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.