Google Sheets: How to enter same text across cells in a column with arrayformula?

Question

Instead of copy/paste same number across cells, I'm trying to utilize arrayformula in google sheets, if it's possible. These didn't work, getting an error message saying "Circular dependency detected. To resolve with iterative calculation, see File > Settings.".

• =arrayformula(A3:A10="1.2%")
• =arrayformula(A3:A10=C1): "1.2%" is entered in C1 cell'

Any suggestion? Thank you!

Answer 1

you can try:

=ARRAYFORMULA(IF(ROW(A3:A10),C1))

OR

=INDEX(SEQUENCE(ROWS(A3:A10),1,1,0)*C1)