I've got a sheet with account numbers in column Q. If the account number is 9 I want it to say "Yay", if not 9, "Boo".
This simple formula doesn't fill down.
Columns E & L on the same sheet have arrayformulas that fill down the column, but Column R won't work. I've tried inserting in a new column and typing the formula fresh in cell R3 and still doesn't fill down.