I have a formula that I want to apply to every row of an extremely long column. The formula for row 1 is...

=IF(AND(NOT(ISERROR(FIND("(";B1)));LEN(C1)>0);1;0)

Essentially, if there is a parenthesis in B's cell and there is anything in C's cell, write '1' - otherwise, write '0'.

I need to apply this to every cell in Column D, and there are 25333 rows in the spreadsheet. I know the standard way is to click and drag the formula down, but that would require me to sit here for an hour with the mouse held down to do. There has to be a better way, right?