2

I'm using Google Spreadsheets and currently, this is what I have in J2: =iferror(H2/G2,0)

I know I can double click the square in the bottom right and it will apply to every cell in the column but if I were to create a new row anywhere in the spreadsheet it would show up as empty. I just want every cell including Newly created cells to be filled with the formula above so it will display the correct data for that row. How do I do this?

migrated from superuser.com Jun 8 '15 at 19:01

This question came from our site for computer enthusiasts and power users.

2

Try:

=ArrayFormula(if(len(H2:H)*len(G2:G), iferror(H2:H/G2:G, 0),))

The formula will output results if there are entries in col H AND col G. See if that works for you ?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy